Writing Syntax for Conditions
For a review of Conditions related to Scenarios please refer to the article here. Conditions, in Scenarios, take the form of a comparison that can create a filter in your table structure.
If you are ever doubting the name of a column that needs to be used in an action, you can type CTRL+SPACE to have the full list of columns available to you displayed. Alternatively, you can start typing and the valid column names will auto-complete.
Allowed Conditions Syntax
Standard comparison operators include: =, >, <, >=, <=, !=. You can also use the LIKE or NOT LIKE operators and the % or * values for wildcards for string comparisons. The % and * wildcard operators are equivalent within Cosmic Frog (though, best practice is to use the % wildcard symbol since this is valid in the database code).
Following are some examples valid condition syntax:
|Business Goal||Condition Syntax|
|Filter for items with unit value above 45||unitvalue>45|
|Apply condition for product with name RM_01||productname=’RM_01′|
|Reference products with demand over 1,000 units including 1,000||quantity>=1000|
|Filter for all Distribution Centers by prefix||facilityname LIKE ‘DC_%’|
|Filter for all Distribution Centers by prefix||facilityname LIKE ‘DC_*’|
|Filter for all Facilities that are not Distribution Centers by prefix||facilityname NOT LIKE ‘DC_%’|
|Filter for all Facilities that are not Distribution Centers by prefix||facilityname NOT LIKE ‘DC_*’|