Skip navigation links

oracle.bpel.services.workflow.repos
Class Predicate

java.lang.Object
oracle.bpel.services.workflow.repos.Predicate

All Implemented Interfaces:

java.io.Serializable

public class Predicate

extends java.lang.Object

implements java.io.Serializable

Since:

release specific (what release of product did this appear in)

See Also:

Serialized Form

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

SYSDATE

public static final java.lang.String SYSDATE

The current date. SQL Standard mandates CURRENT_DATE - Oracle supports SYSDATE or CURRENT_DATE

See Also:

Constant Field Values

OP_EQ

public static final int OP_EQ

equality operation "="

See Also:

Constant Field Values

OP_NEQ

public static final int OP_NEQ

not equal operation "<>"

See Also:

Constant Field Values

OP_GT

public static final int OP_GT

greater than operation ">"

See Also:

Constant Field Values

OP_GTE

public static final int OP_GTE

greater than or equal to operation ">="

See Also:

Constant Field Values

OP_LT

public static final int OP_LT

less than operation "<"

See Also:

Constant Field Values

OP_LTE

public static final int OP_LTE

less than or equal to operation "<="

See Also:

Constant Field Values

OP_LIKE

public static final int OP_LIKE

LIKE operation

See Also:

Constant Field Values

AND

public static final int AND

logical AND (for combining Predicates)

See Also:

Constant Field Values

OR

public static final int OR

logical OR (for combining Predicates)

See Also:

Constant Field Values

OP_IN

public static final int OP_IN

SQL IN (for subqueries)

See Also:

Constant Field Values

OP_NOT_IN

public static final int OP_NOT_IN

SQL NOT IN (for subqueries)

See Also:

Constant Field Values

OP_NOT_LIKE

public static final int OP_NOT_LIKE

String NOT LIKE operation

See Also:

Constant Field Values

OP_CONTAINS

public static final int OP_CONTAINS

String contains operation: LIKE '%foo%'

See Also:

Constant Field Values

OP_NOT_CONTAINS

public static final int OP_NOT_CONTAINS

String does not contain operation: NOT LIKE '%foo%'

See Also:

Constant Field Values

OP_BEGINS

public static final int OP_BEGINS

String begins operation: LIKE 'foo%'

See Also:

Constant Field Values

OP_NOT_BEGINS

public static final int OP_NOT_BEGINS

String does not begin operation: NOT LIKE 'foo%'

See Also:

Constant Field Values

OP_ENDS

public static final int OP_ENDS

String ends operation: LIKE '%foo'

See Also:

Constant Field Values

OP_NOT_ENDS

public static final int OP_NOT_ENDS

String not ends operation: NOT LIKE '%foo'

See Also:

Constant Field Values

OP_BEFORE

public static final int OP_BEFORE

Date before: < 'OCT-25-2005' (this is equivalent of OP_LT, included for convinience...)

See Also:

Constant Field Values

OP_AFTER

public static final int OP_AFTER

Date after: > 'OCT-25-2005' (this is equivalent of OP_GT, included for convinience...)

See Also:

Constant Field Values

OP_ON

public static final 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)

See Also:

Constant Field Values

OP_NEXT_N_DAYS

public static final int OP_NEXT_N_DAYS

Date in next N days opertor: <= SYSDATE + N

See Also:

Constant Field Values

OP_LAST_N_DAYS

public static final int OP_LAST_N_DAYS

Date in last N days opertor: >= SYSDATE - N

See Also:

Constant Field Values

OP_IS_NULL

public static final int OP_IS_NULL

IS NULL operation (can also use OP_EQ and pass a null value)

See Also:

Constant Field Values

OP_IS_NOT_NULL

public static final int OP_IS_NOT_NULL

IS NOT NULL operation (can also use OP_NEQ and pass a null value)

See Also:

Constant Field Values

NUMBER_OF_OPERATORS

public static final int NUMBER_OF_OPERATORS

See Also:

Constant Field Values

VALID_DEFAULT_OPERATORS

public static final boolean[] VALID_DEFAULT_OPERATORS

Operators that can be used with any datatype

VALID_STRING_OPERATORS

public static final boolean[] VALID_STRING_OPERATORS

Operators that can be used with the String datatype

VALID_DATE_OPERATORS

public static final boolean[] VALID_DATE_OPERATORS

Operators that can be used with Date datatype

VALID_JOIN_OPERATORS

public static final boolean[] VALID_JOIN_OPERATORS

Operators that can be used for joining two columns

OPERATOR_NAMES

public static final java.lang.String[] OPERATOR_NAMES

Names of operators indexed by their codes

DATATYPE_NAMES

public static final java.lang.String[] DATATYPE_NAMES

Constructor Detail

Predicate

public Predicate(Column column1,
                 int operation,
                 Column column2)
          throws WorkflowException

Constructor to create the join predicate based on columns. It is used to create the predicate for join

Parameters:

column1 - Column for joining

operation - int opertaion on the predicate

column2 - Column for joining

Throws:

WorkflowException

Predicate

public Predicate(Column column,
                 int operation,
                 java.lang.Object value)
          throws WorkflowException

Constructor to create the simple predicate based on one value.

Parameters:

column - String name of the column

operation - int opertaion on the predicate

value - Object search value

Throws:

WorkflowException

Predicate

public Predicate(Column column,
                 int operation,
                 java.lang.Object value,
                 boolean ignoreCase)
          throws WorkflowException

Constructor to create the simple predicate based on one value.

Parameters:

column - Column object to query against

operation - int opertaion on the predicate

value - Object search value

ignoreCase - boolean true/false

Throws:

WorkflowException

Predicate

public Predicate(Column column,
                 int operation,
                 java.util.List values,
                 boolean ignoreCase)
          throws WorkflowException

Constructor to create the simple predicate based on list of values. It is used to create the predicate for IN

Parameters:

column - Column object to query against

operation - int opertaion on the predicate

values - List search values

Throws:

WorkflowException

Predicate

public Predicate(Column column,
                 int operation,
                 java.util.List values)
          throws WorkflowException

Constructor to create the simple predicate based on list of values. It is used to create the predicate for IN

Parameters:

column - Column object to query against

operation - int opertaion on the predicate

values - Object search value

Throws:

WorkflowException

Predicate

public Predicate(Predicate pred1,
                 int logical,
                 Predicate pred2)
          throws WorkflowException

Constructor to create the Complex predicate. This will append the string from pred1 with pred2 by using logical opeartor

Parameters:

pred1 - Predicate

logical - int logical operaton like AND or OR

pred2 - Predicate

Throws:

WorkflowException

Method Detail

addClause

public void addClause(int logicalOperator,
                      Column column,
                      int operation,
                      java.util.List values,
                      boolean ignoreCase)
               throws WorkflowException

To add the more filtering criteria to existing predicate by using logical operator based on list of values

Parameters:

logicalOperator - int Operator like AND or OR

operation - int Operation to filter the data

values - List of predicate values

ignoreCase - boolean true/false

Throws:

WorkflowException

addClause

public void addClause(int logicalOperator,
                      Column column,
                      int operation,
                      java.util.List values)
               throws WorkflowException

To add the more filtering criteria to existing predicate by using logical operator based on list of values

Parameters:

logicalOperator - int Operator like AND or OR

operation - int Operation to filter the data

values - List of predicate values

Throws:

WorkflowException

addClause

public void addClause(int logicalOperator,
                      Column column,
                      int operation,
                      java.lang.Object value,
                      boolean ignoreCase)
               throws WorkflowException

To add the more filtering criteria to existing predicate by using logical operator based on value

Parameters:

logicalOperator - int Operator like AND or OR

operation - int Operation to filter the data

ignoreCase - boolean true/false

Throws:

WorkflowException

addClause

public void addClause(int logicalOperator,
                      Column column,
                      int operation,
                      java.lang.Object value)
               throws WorkflowException

To add the more filtering criteria to existing predicate by using logical operator based on value

Parameters:

logicalOperator - int Operator like AND or OR

operation - int Operation to filter the data

Throws:

WorkflowException

getOperationNumber

public static int getOperationNumber(java.lang.String operationName)

getOperationNumber returns the operation number for the specified operationName using a lookup of the static map

getOperationName

public static java.lang.String getOperationName(int operationNumber)

getOperationName returns the operation name for the specified operationNumber using a lookup of the static map

getPredicateClauseList

public java.util.List getPredicateClauseList()

getPredicateClauseList returns the predicate clause list

printPredicateStructure

public void printPredicateStructure(java.lang.String msg)

printPredicateStructure is a utility method for printing info in the predicate structure list

getString

public java.lang.String getString()

Return predicate as a string

Returns:

String

toString

public java.lang.String toString()

Return predicate as a string

Returns:

String

getValues

public java.util.List getValues()

Retrun list of predicate values

Returns:

List

addClause

public void addClause(int logicalOperator,
                      Column column1,
                      int operation,
                      Column column2)
               throws WorkflowException

To add the more filtering criteria to existing predicate by using logical operator based on value

Parameters:

logicalOperator - int Operator like AND or OR

operation - int Operation to filter the data

Throws:

WorkflowException

getTables

public java.util.List getTables()

Returns a list of Tables referred to in this predicate. Please note addition of clauses will add more entries to the list. So, call this method after all clauses are added.

Returns:

a list of tables

enableXMLSerialization

public static void enableXMLSerialization(boolean value)

To enable xml serialization for soap client to serialize the predicate

Skip navigation links