For a review of Conditions related to Scenarios please refer to the earlier article here. Conditions, in Scenarios, take the form of a comparison that can create a filter in your table structure.
Allowed Conditions Syntax
Standard comparison operators include: =, >, <, >=, <=, !=. You can also use the LIKE operator 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_*'|