Parameter - Function
The following table describes the different function parameter types.
Description | Parameter type | Data type | Sub-parameters |
P1 > P2 | WFPM_GT | WFDT_BOOLEAN | P1, P2: {int, decimal, string, datetime} |
P1 >= P2 | WFPM_GEQ | WFDT_BOOLEAN | P1, P2: {int, decimal, string, datetime} |
P1 < P2 | WFPM_LT | WFDT_BOOLEAN | P1, P2: {int, decimal, string, datetime} |
P1 <= P2 | WFPM_LEQ | WFDT_BOOLEAN | P1, P2: {int, decimal, string, datetime} |
P1 = P2 | WFPM_EQ | WFDT_BOOLEAN | P1, P2: {int, decimal, string, datetime, GUID, bool}
See Note below. |
P1 <> P2 | WFPM_NEQ | WFDT_BOOLEAN | P1, P2: {int, decimal, string, datetime, GUID, bool}
See Note below. |
P1 is between P2 and P3 | WFPM_BETWEEN | WFDT_BOOLEAN | P1, P2, P3: {int, decimal, string, datetime} |
P1 is one of {P2, … Pn} | WFPM_IN | WFDT_BOOLEAN | P1, P2, …, Pn: {int, decimal, string, datetime, GUID, bool} |
P1 is not null | WFPM_EXIST | WFDT_BOOLEAN | P1 |
Always null | WFPM_NULL | - | - |
Return P1 is null | WFPM_ISNULL | - | P1 |
P1 begins with P2 | WFPM_BEGIN_WITH | WFDT_BOOLEAN | P1, P2: string |
P1 ends with P2 | WFPM_END_WITH | WFDT_BOOLEAN | P1, P2: string |
P1 contains P2 | WFPM_CONTAIN | WFDT_BOOLEAN | P1, P2: string |
Return the length of P1 | WFPM_STRLEN | WFDT_INTEGER | P1, P2: string |
A substring of P1 starting at P2
or A substring of P1 starting at P2 with length P3 |
WFPM_SUBSTR | WFDT_STRING | P1:string; P2: int
or P1: string; P2, P3: int |
P1 && … && Pn | WFPM_AND | WFDT_BOOLEAN | P1, …, Pn:bool |
P1 || … || Pn | WFPM_OR | WFDT_BOOLEAN | P1, …, Pn:bool |
Not P1 | WFPM_NOT | WFDT_BOOLEAN | P1:bool |
Always true | WFPM_TRUE | WFDT_BOOLEAN | - |
Always false | WFPM_FALSE | WFDT_BOOLEAN | - |
If P1 is true, return P2. Otherwise return P3 (or null) | WFPM_IFF | P1, P2, [P3] | |
Return the first non-null value of P1, … Pn | WFPM_CASE | P1, …, Pn | |
P1 + … + Pn | WFPM_ADD | WFDT_INTEGER
WFDT_DECIMAL WFDT_STRING |
P1, …, Pn: {int, decimal, string}
See Note below. |
P1 – P2 | WFPM_SUBTRACTION | WFDT_INTEGER
WFDT_DECIMAL |
P1, P2: {int, decimal}
See Note below. |
P1 * … * Pn | WFPM_MULTIPLICATION | WFDT_INTEGER
WFDT_DECIMAL |
P1, …, Pn: {int, decimal}
See Note below. |
P1 / P2 | WFPM_DIVISION | WFDT_INTEGER
WFDT_DECIMAL |
P1, P2: {int, decimal}
See Note below. |
P1 % P2 | WFPM_MODULUS | WFDT_INTEGER | P1, P2: int |
Absolute value of P1 | WFPM_ABS | WFDT_INTEGER
WFDT_DECIMAL |
P1: {int, decimal} |
Current date time | WFPM_DATE | WFDT_DATETIME | - |
Minute of P1 | WFPM_MINUTE | WFDT_INTEGER | P1: datetime |
Hour of P1 | WFPM_HOUR | WFDT_INTEGER | P1: datetime |
Day of P1 | WFPM_DAY | WFDT_INTEGER | P1: datetime |
Weekday of P1 | WFPM_WEEKDAY | WFDT_INTEGER | P1: datetime |
Month of P1 | WFPM_MONTH | WFDT_INTEGER | P1: datetime |
Year of P1 | WFPM_YEAR | WFDT_INTEGER | P1: datetime |
P1 + P2(year) + P3(month) + P4(day) + P5(hour) + P6(minute) | WFPM_DATEADD | WFDT_DATETIME | P1: datetime; P2, P3, P5, P6: int |
All activities were completed | WFPM_ALL_ACTIVITIES | WFDT_BOOLEAN | - |
Any actions of current step were failed | WFPM_ANY_ACTION | WFDT_BOOLEAN | - |
Subject1 equals to Subject2 or Subject2 is at high-level hierarchy to Subject1 | WFPM_MATCH_SUBJECTS | WFDT_BOOLEAN | Subject1, Subject2: GUID |
Get the ID of user queue by queue type | WFPM_USER_QUEUE | WFDT_GUID | User: GUID,
QueueType: int |
Get the ID of incident queue | WFPM_INCIDENT_QUEUE | WFDT_GUID | IncidentId: GUID |
Note When using datatype WFDT_DECIMAL, you should use caution with functions that test equality (WFPM_EQ and WFPM_NEQ) and include the mathematic operators WFPM_ADD, WFPM_SUBTRACTION, WFPM_MULTIPLICATION or WFPM_DIVISION. Rounding of the WFDT_DECIMAL value can cause unexpected results from these operations.
See Also