Comparing a value in the form with a column in database field value with same name

Question

Hi , 
 I am new to Appian. I have a value in the form to be input by the user .After user enters the value ,I wanted to check if the same value in one of my table column. 
 I have used User Input Task for creating form and using Query Database as the smart services.I have specified the below query to retrieve the value from database in Query Database Smart Services.

I am using the below flow in my process model 
 
 Thanks in Advance.

Stewart Burchell · Accepted Answer

What are you going to do if the value entered by the User DOES appear in your database column? If you want this to be a validation error and route back to the 'Verify PO form' as an error for the User to resolve, then you can do this all in the same form. If not, what is the objective here?

ManuelHTG · Answer

I think you should consider using a different approach, for instance make use of an expression rule with a query database entity instead of using an SQL statement on the process model directly. 
 then on the process model, use the script task to call your expression rule.

Comparing a value in the form with a column in database field value with same name

Top Replies