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
Replies
9 replies
Subscribers
7 subscribers
Views
4934 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
We have a need to do a select query. The "WHERE" of the SQL statement
scotte
over 10 years ago
We have a need to do a select query. The "WHERE" of the SQL statement will need to be dynamic.The reason is that this is a "search" that our users are doing. They may select to search on 1 to 5 fields. In other words, the columns in our where clause will vary depending on the user situation. When using the Query Database smart node, we are struggling to find a way to accomplish this. Is there a way to get this done? Thanks!...
OriginalPostID-131608
OriginalPostID-131608
Discussion posts and replies are publicly visible
Parents
0
Tim
Certified Lead Developer
over 10 years ago
Try using queryentity() or queryrecord() instead. These functions provide much more powerful query options and allow for dynamic where conditions. See the examples here for a starter:
forum.appian.com/.../Query_Recipes.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Tim
Certified Lead Developer
over 10 years ago
Try using queryentity() or queryrecord() instead. These functions provide much more powerful query options and allow for dynamic where conditions. See the examples here for a starter:
forum.appian.com/.../Query_Recipes.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data