Transcript uniflow validation example jdh 07282015

Uniflow validations can be performed a few ways in uniflow. In this power point I will show you
two common ways we validate values in the Uniflow UI
In the above example, the text box “ftaBc” has 2 validations. These validations are indented
under the text box and are called by the tag “validate~”. The SQL statement after the validate
tag must always be true on the submission of the form or the error message, defined by the tag’
will “errorMessage~” be displayed for the user
The logic for the first validation reads as: “Do not select 1 from the database table containers
where the container ID value is the same as the value entered for the text box “ftaBc” and
where the record in the containers table is also a type ‘FTA Card’”. This is a typical validation to
prevent a duplication of IDs being entered into a database table
The logic for the second validation reads as: “Do not select 1 from the form where the text
box ftaBc is blank” this is a typical validation preventing a user from entering a blank value
into the form on the submit.
Here is a second method for validations. This requires the “validateSql” tag which is a child of
step, the same indention level of the form tag. These statements are also evaluated on the
submit of the form and they will display the error message if they are not true.
The logic for the first validation reads as: “Select 1 from the queues table where the containerId
is equal to the form value requisition id and the step for that container is equal to
‘Review Requisition’” this is a typical validate to ensure that the item you are working on in the
form is actually queued to that step.
These validation can become involved. They use SQL rules. Can be comprised of RegEx.
Can be specific to just form values or values from the database or both.
Testing for a negative. Using the “!” before you select statement in the validation will allow
you to test for a negative. i.e. “Allow all other conditions to pass without issue except for
this one condition”