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
7 replies
Subscribers
5 subscribers
Views
2237 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
I am using the Query Data base smart service and need to use a select with an in
karls
over 7 years ago
I am using the Query Data base smart service and need to use a select with an in clause. Passing in "'VALUE1",'VALUE2'" does not seem to work. Please do let me know if there is an alternative.
OriginalPostID-229703
OriginalPostID-229703
Discussion posts and replies are publicly visible
0
Mike Schmitt
Certified Lead Developer
over 7 years ago
Just checking, is there any possibility you could use Query Entity instead of the Query DB smart service? I know there are some things that only the Smart Service can do, but QE is far more flexible if you don't have one of the few cases that it can't do.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
karls
over 7 years ago
Thanks. Can I run a query this from a script task.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Mike Schmitt
Certified Lead Developer
over 7 years ago
Yes, definitely - you can use either a query rule (the older style, which I don't recommend using unless you specifically need it), an expression rule with a Query Entity in it (usually best), or even just build the Query Entity straight into the output of the script task.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
karls
over 7 years ago
Don't think Query entity supports joins. I need to do a join with multiple tables.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Mike Schmitt
Certified Lead Developer
over 7 years ago
I think the best practice in that case is to create a persistent View (in which your required joins are accounted for already), and create a matching data store entity, and when you need to access the data in-process, query against that using Query Entity / etc. Is there any particular reason this approach wouldn't work?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
karls
over 7 years ago
That would work. Thanks a lot for your help on this.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Mike Schmitt
Certified Lead Developer
over 7 years ago
Glad to help - good luck! And feel free to post back if you need any tips on getting your QE to work (in case you're not already familiar with them).
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel