Operator |
Description |
Example |
Explanation |
|
equal |
Equal to (=) |
Engine Serial Number equal 60844694. |
The trigger will consider all those work orders where Engine Serial Number of the asset is equal to 60844694. |
|
not Equal |
Not equal to (!=) |
Engine Serial Number not equal 60844695 |
The trigger will consider all those work orders where Engine Serial Number of the asset is anything except 60844695. |
|
greater |
Greater than (>) |
Work Order Creation Date greater 2024-03-31 00:00:00. |
The trigger will consider all those work orders which were created after 2024-03-31 00:00:00. |
|
greater or equal |
Greater than or equal to (>=) |
Work Order Creation Date greater or equal 2024-03-31 00:00:00. |
The trigger will consider all those work orders which were created on or after 2024-03-31 00:00:00. |
|
between |
Within a given range (<= a <=) |
Asset Build Date between (2024-01-01 00:00:00 , 2024-07-31 00:00:00). |
The trigger will consider all those work orders where the Asset Build Date is between 2024-01-01 00:00:00 and 2024-07-31 00:00:00. |
|
not between |
Outside a given range (< a or a>) |
Asset Build Date not between (2022-01-01 00:00:00 , 2022-12-31 00:00:00). |
The trigger will consider all those work orders where the Asset was built is either before 2022-01-01 00:00:00 or after 2022-12-31 00:00:00. |
|
less |
Less than (<) |
Work Order Creation Date Less 2024-03-31 00:00:00. |
The trigger will consider all those work orders which were created before 2024-03-31 00:00:00. |
|
less or equal |
Less than or equal to (<=) |
Work Order Creation Date Less or equal 2024-03-31 00:00:00. |
The trigger will consider all those work orders which were created on or before 2024-03-31 00:00:00. |
|
contains |
Contains (%string%) |
Service Model Number contains CM24 |
The trigger will consider all those work orders where Service Model Number of the asset contains “CM24”. |
|
begins with |
Starts with (%string) |
Service Model Number begins with X15 |
The trigger will consider all those work orders where Service Model Number of the asset begins with “X15”. |
|
ends with |
Ends with (string%) |
Service Model Number ends with L126B |
The trigger will consider all those work orders where Service Model Number of the asset ends with “L126B”. |
|
in |
In (a, b, c) |
Fault Code in (111, 114, 1117) |
The trigger will consider all those work orders where the Fault Code is either 111, 114 or 1117. |
|
not in |
Not in (a, b, c) |
Fault Code not in (555, 556) |
The trigger will consider all those work orders where the Fault Code is neither 555 nor 556. |