Is Shift Pattern Property Generic Condition

com.workbrain.app.ta.conditions.IsShiftPatternPropertyGenericCondition

The Is Shift Pattern Property Generic Condition lets you check the shift pattern properties for a specified value as of the calculation date. The criteria is provided in an expression string parameter using shift pattern fields in a comma-delimited quote-enclosed string.

Parameters In

Name Type Description Example
Expression String String A comma-delimited, quote-enclosed string of fields of a table, where each condition is ANDed.

Fields of tables are referenced by taking underscore (_) from field names and capitalizing what comes after the underscores. For example, shftpatStartDate.

Supported operators are =, !=, <>, <, <=, >, >=, [CONTAINS], [IN](item1;item2;item3), [NOT_IN](item1;item2;item3), [IS_EMPTY], and [IS_NOT_EMPTY].

"shftpatStartDate>2017-01-01 00:00:00"

"shftpatDesc=Day shift Monday to Friday"

"shftpatFlag1=Y"