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
5 replies
Subscribers
7 subscribers
Views
1786 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Hi all, I am just wondering what would be the best way to design a qu
moritzw
over 11 years ago
Hi all,
I am just wondering what would be the best way to design a query of a datastore with dynamic search parameters? If I use query rules I have to create X! query rules for X possible search parameters. Is there a way to inject dynamic sql into a query database node? Also it would be a very handy enhancement for query rules to support dynamic queries.
Thanks, Moritz...
OriginalPostID-69755
OriginalPostID-69755
Discussion posts and replies are publicly visible
Parents
0
Alex Weller
Appian Employee
over 11 years ago
Moritz, if you are using strings, you can design your query rule to use the "includes" operator. These inputs can then either be used or unused and should still return valid results. Number and date inputs can be designed as ranges (start input and end input) with all encompassing defaults. If modified they will narrow down results, if unused they would not affect the results.
Hope it helps!
Alex
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Alex Weller
Appian Employee
over 11 years ago
Moritz, if you are using strings, you can design your query rule to use the "includes" operator. These inputs can then either be used or unused and should still return valid results. Number and date inputs can be designed as ranges (start input and end input) with all encompassing defaults. If modified they will narrow down results, if unused they would not affect the results.
Hope it helps!
Alex
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data