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 Bishnu Panigrahi
Appian Employee
over 12 years ago

Regarding making a query rule:
As Iain suggests, making a view on those 10 fields can help with making the search query rule. Also, the "includes" operator can handle null rule inputs in query rules. So if each field's query condition uses the "includes" operator, you won't have to filter out your null values for the query rule to execute. For more info:
forum.appian.com/.../Rules
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Bishnu Panigrahi
Appian Employee
over 12 years ago

Regarding making a query rule:
As Iain suggests, making a view on those 10 fields can help with making the search query rule. Also, the "includes" operator can handle null rule inputs in query rules. So if each field's query condition uses the "includes" operator, you won't have to filter out your null values for the query rule to execute. For more info:
forum.appian.com/.../Rules
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data