What is the best way to achive: I have a form with around 10(country, ssn,

raghunandanj3904

Certified Senior Developer

over 12 years ago

What is the best way to achive:
I have a form with around 10(country, ssn, fname, lname, age, etc) search criteria fields. User is required to mandatorily enter only one field. Rest 9 are optional.
In this case, what would be the best implementation way?? I need to fetch the records from the DB(2 different tables) for the entered criteria. If I use Query Database, how my SQL looks like since the where clause is dependent on the user input.
Any guideline / document would be of great help.
TIA....

Discussion posts and replies are publicly visible

Parents

0 iainf over 12 years ago

One option would be to have a "length(trim(filternulls({pv!one,..., pv!ten}))) = 1" decision straight after the form and direct back if false. Then you could display an error flag 'Please enter only one search criteria'. You can use the same node to direct the flow depending on the entered value.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 iainf over 12 years ago

One option would be to have a "length(trim(filternulls({pv!one,..., pv!ten}))) = 1" decision straight after the form and direct back if false. Then you could display an error flag 'Please enter only one search criteria'. You can use the same node to direct the flow depending on the entered value.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data