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.