Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
+1
person also asked this
people also asked this
Replies
8 replies
Subscribers
8 subscribers
Views
6955 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Is there any way by which we can create a dynamic SQL query and implement
ankitt
over 9 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?...
OriginalPostID-125741
OriginalPostID-125741
Discussion posts and replies are publicly visible
Parents
0
Arpit Bhargava
over 6 years ago
Hi Ankit
You can do two things
1. Save the SQL query in the database and use the query entity to hit the SQL query using the process.
2. Use the function executesqlquery() function to execute.
With the help of the database , it will be helpful to have execution of SQL queries dynamically.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Arpit Bhargava
over 6 years ago
Hi Ankit
You can do two things
1. Save the SQL query in the database and use the query entity to hit the SQL query using the process.
2. Use the function executesqlquery() function to execute.
With the help of the database , it will be helpful to have execution of SQL queries dynamically.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data