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
8 subscribers
Views
4418 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 9 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 9 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 9 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