oracle.tip.pc.api.worklist
Interface IPredicate

All Superinterfaces:

WorklistColumns

public interface IPredicate

extends WorklistColumns

Field Summary

static int	AND logical AND (for combining Predicates)
static java.lang.String	ASSIGNEE
static java.lang.String	COMMENTS
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_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	OR logical OR (for combining Predicates)

Fields inherited from interface oracle.tip.pc.api.worklist.WorklistColumns

ACQUIREDBY, APPROVERS, CONCLUSION, CREATEDDATE, CREATOR, DOMAINID, EXPIRATIONDATE, EXPIRATIONDURATION, FLEXDATE1, FLEXDATE2, FLEXDATE3, FLEXDOUBLE1, FLEXDOUBLE2, FLEXLONG1, FLEXLONG2, FLEXSTRING1, FLEXSTRING2, FLEXSTRING3, FLEXSTRING4, IDENTIFICATIONKEY, INSTANCEID, MODIFYDATE, OWNER, PATTERN, PRIORITY, PROCESSID, PROCESSNAME, PROCESSVERSION, STATE, SUBSTATE, TASKGROUPID, TASKID, TASKNUMBER, TASKTYPE, TITLE, UPDATEDBY, VERSION

Method Summary

void	addClause(int logicalOperator, java.lang.String columnName, 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, java.lang.String columnName, 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, java.lang.String columnName, 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, java.lang.String columnName, int operation, java.lang.Object value, boolean ignoreCase) To add the more filtering criteria to existing predicate by using logical operator based on value

Field Detail

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

COMMENTS

public static final java.lang.String COMMENTS

See Also:

Constant Field Values

ASSIGNEE

public static final java.lang.String ASSIGNEE

See Also:

Constant Field Values

Method Detail

addClause

public void addClause(int logicalOperator,
                      java.lang.String columnName,
                      int operation,
                      java.util.List values)
               throws PCException

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

columnName - String name of the column

operation - int Operation to filter the data

values - List of predicate values

Throws:

PCException

addClause

public void addClause(int logicalOperator,
                      java.lang.String columnName,
                      int operation,
                      java.util.List values,
                      boolean ignoreCase)
               throws PCException

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

columnName - String name of the column

operation - int Operation to filter the data

values - List of predicate values

ignoreCase - boolean true/false

Throws:

PCException

addClause

public void addClause(int logicalOperator,
                      java.lang.String columnName,
                      int operation,
                      java.lang.Object value)
               throws PCException

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

Parameters:

logicalOperator - int Operator like AND or OR

columnName - String name of the column

operation - int Operation to filter the data

Throws:

PCException

addClause

public void addClause(int logicalOperator,
                      java.lang.String columnName,
                      int operation,
                      java.lang.Object value,
                      boolean ignoreCase)
               throws PCException

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

Parameters:

logicalOperator - int Operator like AND or OR

columnName - String name of the column

operation - int Operation to filter the data

ignoreCase - boolean true/false

Throws:

PCException