Is there any way by which we can create a dynamic SQL query and implement

ankitt over 10 years ago

Is there any way by which we can create a dynamic SQL query and implement it in Appian?

I have a requirement where there are 5 textfields(name, DOB, age, address and phone) and on the basis of input in these textfields want data from database. If user gives input to any 1 of the field or combination of fields, then data should be queried on the basis of all the filled fields

Is there any solution to such a problem?...

Discussion posts and replies are publicly visible

Parents

0 josep
Certified Lead Developer
over 7 years ago

If you really need to make the queyr i the database then the best option is to create whe dynamic query inside a procedure, but for my it doesn't sounds like something oyu want to do that way because you need the values in appian ,So, Your requirement sounds more like a rule using queryEntity with lot of validations(if's) on the rule inputs parameters
which will give you the queryFilter

Not exactly but sometihng similar to the answer that Ram gave to this question
community.appian.com/.../query-needs-to-be-dynamically-created-based-on-the-search-fields-using-a-queryentity

I Hope this helps

Best Regards
Jose Perez
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 josep
Certified Lead Developer
over 7 years ago

If you really need to make the queyr i the database then the best option is to create whe dynamic query inside a procedure, but for my it doesn't sounds like something oyu want to do that way because you need the values in appian ,So, Your requirement sounds more like a rule using queryEntity with lot of validations(if's) on the rule inputs parameters
which will give you the queryFilter

Not exactly but sometihng similar to the answer that Ram gave to this question
community.appian.com/.../query-needs-to-be-dynamically-created-based-on-the-search-fields-using-a-queryentity

I Hope this helps

Best Regards
Jose Perez
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data