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
14 replies
Subscribers
5 subscribers
Views
4035 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
Hi you all, I need to use a Query DB with more "where" variable
Giobis
over 11 years ago
Hi you all,
I need to use a Query DB with more "where" variable... In the Setup Tab I tried to force a node variable but it doesn't works.
The Query that I used is:
SELECT count(purchaserequisition.prno) as prno FROM purchaserequisition,pritem WHERE pritem.prchasereqisition_item_prno=purchaserequisition.prno AND purchaserequisition.plant=ac!plantId ac!OtherAndValue
So in the ac!OtherAndvalue there are others process variable that i send to this query BUT it doesn't works.
Any suggestion for solving this doubt?
Thanks...
OriginalPostID-68190
OriginalPostID-68190
Discussion posts and replies are publicly visible
0
Giobis
over 11 years ago
Thanks Eduardo. I followed both ways and I think that the executequery function is better for flexibility about the dynamic query. The problem is : is it supported for Appian 7.2 ? :(
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 11 years ago
Yes it works with Appian 7.2 but it is not an out of the box function, it is a plug-in.
The plug-in is available for download here in Appian Forum under the "Shared Components" section (
forum.appian.com/.../components)-
"Libraries and Utilities" - "View all Libraries and Utilities" -
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 11 years ago
- "View all Libraries and Utilities" - "Advanced Form Utilities"
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Giobis
over 11 years ago
Thanks for all..
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
<