|
Oracle BPEL Process Manager Workflow Services API Reference 10g Release 3 (10.1.3) B28985-02 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object
oracle.bpel.services.workflow.repos.Predicate
Field Summary | |
static int |
AND logical AND (for combining Predicates) |
static java.lang.String[] |
DATATYPE_NAMES |
static int |
NUMBER_OF_OPERATORS |
static int |
OP_AFTER Date after: > 'OCT-25-2005' (this is equivalent of OP_GT, included for convinience...) |
static int |
OP_BEFORE Date before: < 'OCT-25-2005' (this is equivalent of OP_LT, included for convinience...) |
static int |
OP_BEGINS String begins operation: LIKE 'foo%' |
static int |
OP_CONTAINS String contains operation: LIKE '%foo%' |
static int |
OP_ENDS String ends operation: LIKE '%foo' |
static int |
OP_EQ equality operation "=" |
static int |
OP_GT greater than operation ">" |
static int |
OP_GTE greater than or equal to operation ">=" |
static int |
OP_IN SQL IN (for subqueries) |
static int |
OP_IS_NOT_NULL IS NOT NULL operation (can also use OP_NEQ and pass a null value) |
static int |
OP_IS_NULL IS NULL operation (can also use OP_EQ and pass a null value) |
static int |
OP_LAST_N_DAYS Date in last N days opertor: >= SYSDATE - N |
static int |
OP_LIKE LIKE operation |
static int |
OP_LT less than operation "<" |
static int |
OP_LTE less than or equal to operation "<=" |
static int |
OP_NEQ not equal operation "<>" |
static int |
OP_NEXT_N_DAYS Date in next N days opertor: <= SYSDATE + N |
static int |
OP_NOT_BEGINS String does not begin operation: NOT LIKE 'foo%' |
static int |
OP_NOT_CONTAINS String does not contain operation: NOT LIKE '%foo%' |
static int |
OP_NOT_ENDS String not ends operation: NOT LIKE '%foo' |
static int |
OP_NOT_IN SQL NOT IN (for subqueries) |
static int |
OP_NOT_LIKE String NOT LIKE operation |
static int |
OP_ON Date on operator:TRUNC(date_col) == TRUNC('25-10-2005') (checks for dates falling on the same day, rather than exact date equality) |
static java.lang.String[] |
OPERATOR_NAMES Names of operators indexed by their codes |
static int |
OR logical OR (for combining Predicates) |
static java.lang.String |
SYSDATE The current date. |
static boolean[] |
VALID_DATE_OPERATORS Operators that can be used with Date datatype |
static boolean[] |
VALID_DEFAULT_OPERATORS Operators that can be used with any datatype |
static boolean[] |
VALID_JOIN_OPERATORS Operators that can be used for joining two columns |
static boolean[] |
VALID_STRING_OPERATORS Operators that can be used with the String datatype |
Constructor Summary | |
Predicate(Column column1, int operation, Column column2) Constructor to create the join predicate based on columns. |
|
Predicate(Column column, int operation, java.util.List values) Constructor to create the simple predicate based on list of values. |
|
Predicate(Column column, int operation, java.util.List values, boolean ignoreCase) Constructor to create the simple predicate based on list of values. |
|
Predicate(Column column, int operation, java.lang.Object value) Constructor to create the simple predicate based on one value. |
|
Predicate(Column column, int operation, java.lang.Object value, boolean ignoreCase) Constructor to create the simple predicate based on one value. |
|
Predicate(Predicate pred1, int logical, Predicate pred2) Constructor to create the Complex predicate. |
Method Summary | |
void |
addClause(int logicalOperator, Column column1, int operation, Column column2) To add the more filtering criteria to existing predicate by using logical operator based on value |
void |
addClause(int logicalOperator, Column column, int operation, java.util.List values) To add the more filtering criteria to existing predicate by using logical operator based on list of values |
void |
addClause(int logicalOperator, Column column, int operation, java.util.List values, boolean ignoreCase) To add the more filtering criteria to existing predicate by using logical operator based on list of values |
void |
addClause(int logicalOperator, Column column, int operation, java.lang.Object value) To add the more filtering criteria to existing predicate by using logical operator based on value |
void |
addClause(int logicalOperator, Column column, int operation, java.lang.Object value, boolean ignoreCase) To add the more filtering criteria to existing predicate by using logical operator based on value |
static void |
enableXMLSerialization(boolean value) To enable xml serialization for soap client to serialize the predicate |
static java.lang.String |
getOperationName(int operationNumber) getOperationName returns the operation name for the specified operationNumber using a lookup of the static map |
static int |
getOperationNumber(java.lang.String operationName) getOperationNumber returns the operation number for the specified operationName using a lookup of the static map |
java.util.List |
getPredicateClauseList() getPredicateClauseList returns the predicate clause list |
java.lang.String |
getString() Return predicate as a string |
java.util.List |
getTables() Returns a list of Tables referred to in this predicate. |
java.util.List |
getValues() Retrun list of predicate values |
void |
printPredicateStructure(java.lang.String msg) printPredicateStructure is a utility method for printing info in the predicate structure list |
java.lang.String |
toString() Return predicate as a string |
Methods inherited from class java.lang.Object |
equals, getClass, hashCode, notify, notifyAll, wait, wait, wait |
Field Detail |
public static final java.lang.String SYSDATE
public static final int OP_EQ
public static final int OP_NEQ
public static final int OP_GT
public static final int OP_GTE
public static final int OP_LT
public static final int OP_LTE
public static final int OP_LIKE
public static final int AND
public static final int OR
public static final int OP_IN
public static final int OP_NOT_IN
public static final int OP_NOT_LIKE
public static final int OP_CONTAINS
public static final int OP_NOT_CONTAINS
public static final int OP_BEGINS
public static final int OP_NOT_BEGINS
public static final int OP_ENDS
public static final int OP_NOT_ENDS
public static final int OP_BEFORE
public static final int OP_AFTER
public static final int OP_ON
public static final int OP_NEXT_N_DAYS
public static final int OP_LAST_N_DAYS
public static final int OP_IS_NULL
public static final int OP_IS_NOT_NULL
public static final int NUMBER_OF_OPERATORS
public static final boolean[] VALID_DEFAULT_OPERATORS
public static final boolean[] VALID_STRING_OPERATORS
public static final boolean[] VALID_DATE_OPERATORS
public static final boolean[] VALID_JOIN_OPERATORS
public static final java.lang.String[] OPERATOR_NAMES
public static final java.lang.String[] DATATYPE_NAMES
Constructor Detail |
public Predicate(Column column1, int operation, Column column2) throws WorkflowException
column1
- Column for joiningoperation
- int opertaion on the predicatecolumn2
- Column for joiningWorkflowException
public Predicate(Column column, int operation, java.lang.Object value) throws WorkflowException
column
- String name of the columnoperation
- int opertaion on the predicatevalue
- Object search valueWorkflowException
public Predicate(Column column, int operation, java.lang.Object value, boolean ignoreCase) throws WorkflowException
column
- Column object to query againstoperation
- int opertaion on the predicatevalue
- Object search valueignoreCase
- boolean true/falseWorkflowException
public Predicate(Column column, int operation, java.util.List values, boolean ignoreCase) throws WorkflowException
column
- Column object to query againstoperation
- int opertaion on the predicatevalues
- List search valuesWorkflowException
public Predicate(Column column, int operation, java.util.List values) throws WorkflowException
column
- Column object to query againstoperation
- int opertaion on the predicatevalues
- Object search valueWorkflowException
public Predicate(Predicate pred1, int logical, Predicate pred2) throws WorkflowException
pred1
- Predicatelogical
- int logical operaton like AND or ORpred2
- PredicateWorkflowException
Method Detail |
public void addClause(int logicalOperator, Column column, int operation, java.util.List values, boolean ignoreCase) throws WorkflowException
logicalOperator
- int Operator like AND or ORoperation
- int Operation to filter the datavalues
- List of predicate valuesignoreCase
- boolean true/falseWorkflowException
public void addClause(int logicalOperator, Column column, int operation, java.util.List values) throws WorkflowException
logicalOperator
- int Operator like AND or ORoperation
- int Operation to filter the datavalues
- List of predicate valuesWorkflowException
public void addClause(int logicalOperator, Column column, int operation, java.lang.Object value, boolean ignoreCase) throws WorkflowException
logicalOperator
- int Operator like AND or ORoperation
- int Operation to filter the dataignoreCase
- boolean true/falseWorkflowException
public void addClause(int logicalOperator, Column column, int operation, java.lang.Object value) throws WorkflowException
logicalOperator
- int Operator like AND or ORoperation
- int Operation to filter the dataWorkflowException
public static int getOperationNumber(java.lang.String operationName)
public static java.lang.String getOperationName(int operationNumber)
public java.util.List getPredicateClauseList()
public void printPredicateStructure(java.lang.String msg)
public java.lang.String getString()
public java.lang.String toString()
public java.util.List getValues()
public void addClause(int logicalOperator, Column column1, int operation, Column column2) throws WorkflowException
logicalOperator
- int Operator like AND or ORoperation
- int Operation to filter the dataWorkflowException
public java.util.List getTables()
public static void enableXMLSerialization(boolean value)
|
Oracle BPEL Process Manager Workflow Services API Reference 10g Release 3 (10.1.3) B28985-02 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
Copyright © 2006, Oracle. All rights reserved.