TransLution Standard Decisions


The decisions shown here do not work against a specific ERP. For SYSPRO specific decisions please go here


Decision Name

SQL Query

Comment

IsTextNumeric


Returns a TRUE if the entered value is numeric

DoStepsMatch


Returns a TRUE if the two values passed to the decision are the same

IsLength


Checks the barcode length and returns true or false. You can specify the length required and the operator (e.g. greater than, less than, = etc.)

DoesDataExistDecision

SELECT * FROM ValueViewOrTable WHERE  ColumnName  = @SourceData 

Returns a true if the data exists in the dtaabase table specified

CompareValues


You pass this decision 2 values and an operator. If the condition is true (E.g. A < B) the a True is returned

FindStringInValueDecision


Returns a TRUE if the scanned data contains the specified string

IsStringEmpty


Returns a TRUE if the string passed to the decision is empty.