Introduction

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. 

CompareDateValues

Returns a TRUE if the Condition is met. You pass 2 data values and an operator. So for example Date1, Date2 and '>' If Date1 is > Date2 then TRUE otherwise FALSE.

Supported date formats are yyyymmdd, yyyy/mm/dd,  yyyy-mm-dd, mm-dd-yyyy, mm/dd/yyyy