Hi all, I am just wondering what would be the best way to design a qu

moritzw over 12 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...

Discussion posts and replies are publicly visible

Parents

0 subhankarb over 12 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 12 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