Introduction

Validation Name

SQL Query

Error Message

ValidateBusinessObject

SELECT DISTINCT BUSINESS_OBJECT_NAME FROM dbo.SYSPRO_BUSINESS_OBJECT WITH (NOLOCK) WHERE BUSINESS_OBJECT_NAME = @BusinessObject 

1.Invalid business Object.

IsStepValueNumeric

1.This is not a numeric value.

IsStepValueInteger*

Negative integer values are also allowed

1.This is not an integer value  2.This is not a numeric value.

IsStepValueAEqualStepValueB

Usage: in a transfer your source and target may not be the same. This is an easy way to check that.

1.This value has been scanned previously.                           

2.Values are not equal.                         

3.Values are equal.

IsDataFoundInTableOrView

 SELECT * FROM ValueViewOrTable  WITH (NOLOCK) WHERE  ColumnName  = @Value

1.The data does not exist.

IsDataNotFoundInTableOrView

SELECT * FROM  ValueViewOrTable  WITH (NOLOCK) WHERE ColumnName  = @Value 

1.This data already exists.

TestOperatorLength

Usage: This checks that the barcode is the correct length. You can map any operator such as =, >, >=, <, <=. If you want your barcode to be between 5 and 10 char long for example, use this manipulation twice with < and then with <

1.The scanned value is not the correct length.     

2.The length of the scanned value is too short.  

3.The length of the scanned value is too long.   

4.Operator is not valid.

TestOperatorValue

Usage: This is the perfect validation rule to use to ensure that your scanned values are in the correct numeric range. For example if you need to be sure your value is only between 0 and 100 you use this validation to set the lower limit and then again to set your upper limit. Works on numberic value only. For two strings equal to each other, use IsStepValueAEqualStepValueB

1.Length value is not numeric .                  

2.This value is not equal to the required value.    

3.The values cannot be equal.                      

4.This value is not greater than the required value.

5.This value is not less than the required value.      

6.This value is not greater or equal to the required value. 

7.This value is not less or equal to the required value.    

8.Operator is not valid.  

ValidateUserPassword

SELECT Password FROM TRANSLUTION_UTILITY_CONTROL.dbo.[USER] WITH (NOLOCK) WHERE LoginName = @LoginName

1.Invalid Password.                                         

2.User Not Found.

IsInString

Usage: You can define what text or numeric element must appear in a barcode and both the minimum and maximum number of times it should appear. So, for example, you expect a barcode of A100~XYZ~111. You would look for ~ to appear minimum and maximum 2 times. If you do not care about either min or max, leave them unmapped

1.In String Validation Failed.