Is Work Summary Property Generic Condition

com.workbrain.app.ta.conditions.IsWorkSummaryPropertyGenericCondition

The Is Work Summary Property Generic Condition determines whether a specified expression string is true or false. The condition can examine any work summary attribute or flag for a work summary column.

The condition parses the supplied expression string and checks whether the work summary satisfies the conditions.

Parameters In

Parameter Description
Expression String Specify a comma-delimited, quote-enclosed string of work summary table attributes. For example, you could check if the work summary flag is checked with an expression string "wrksFlag1=Y". If you use multiple conditions, each condition is joined in the query with an AND statement.

The string is case-sensitive. Specify column names in lower case, except for the first letter to the right of the underscore. Also, remove the underscores from the column name. For the column WRKS_FLAG1, specify wrksFlag1.

Dates must be supplied in SQL_TIMESTAMP_FORMAT, which are yyyy-MM-dd, yyyy-MM-dd HH:mm:ss, HH:mm:ss, and yyyy-MM-dd HH:mm. For values that are supplied in HH:mm:ss format, date comparison is made based on day fraction minutes.

Supported operators are =, !=, <>, <, <=, >, >=, [CONTAINS], [IN](item1;item2;item3), [NOT_IN](item1;item2;item3), [IS_EMPTY], and [IS_NOT_EMPTY]. For [IS_EMPTY] and [IS_NOT_EMPTY], the second operand is not required and is ignored.

The condition returns TRUE or FALSE, depending on how the expression string resolves. FALSE is returned if the expression string is not formatted properly, the attributes do not exist, or the types are not compatible.

Example: [IN] operator

This example returns TRUE if the work summary UDF5 value is set to 'van' or 'truck':

"wrksUdf5[IN](van;truck)"

Example: [CONTAINS] operator

This example returns TRUE if the work summary UDF1 value contains Hello:

"wrksUdf1[CONTAINS]Hello"

The condition ignores the case of the configured substring that is being searched (in this case, Hello). For example, if WRKS_UDF1 is set to 'HELLO WORLD', the condition returns TRUE.

If WRKS_UDF1 is set to 'HI WORLD', the condition returns FALSE.