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
1783 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
subhankarb
over 11 years ago
Yes Moritzw...thats how the includes operator works. It ignores all the null value. Best way of doing it would be writing a stored procedure in DB and calling it in Appian.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
subhankarb
over 11 years ago
Yes Moritzw...thats how the includes operator works. It ignores all the null value. Best way of doing it would be writing a stored procedure in DB and calling it in Appian.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data