Friday, May 10, 2019

Transaction Saved Search: The System Treats the Filter Not By the Integer Sign But Based On the Absolute Value of the Quantity Field When Setting the Latter as Criteria Filter

The reason behind this is because in the Transaction Saved Search logic, the Quantity field is not treated as a Numeric data type and therefore would not consider the integer sign in the latter field.

In order to pull up information based by the integer sign; convert the Quantity field to a Numeric data type.  To do this, add another filter that sets the integer sign validation. 

Example: Criteria tab>Standard subtab>Filter column: Quantity = is less than 5

Add a filter under: Criteria tab>Standard subtab>Filter column: Formula (Numeric) | Formula: {quantity} | Formula (Numeric) = not less than | Value = 5

No comments:

Post a Comment