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
3 replies
Subscribers
5 subscribers
Views
2504 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
I'm attempting to pass a parameter into a Query Database Smart Service node.
christaj
over 11 years ago
I'm attempting to pass a parameter into a Query Database Smart Service node. I'm attempting to query our Oracle Data Store using a pre-defined data source. The query works fine when I hard-code a value into the query so I know my SQL syntax is correct.
The query is as follows:
select "id", "date", "approved", "available", "location", "datetexttest", "expedited", "assignedarb", "arbid", "arbname" from "arbitdates" where "available" = 1 and "approved" = 1 and "arbid" = ac!selectedArbId and "expedited" = ac!expeditedvalue
The passed values is the ac!expeditedvalue and ac!selectedArbId. I've created an input value of this name and set the value to the process variable I'd like to use. However, when I do this the query returns a null value in all the output fields. Am I doing this correctly?...
OriginalPostID-71270
OriginalPostID-71270
Discussion posts and replies are publicly visible
Parents
0
akhilan
over 11 years ago
Can you verify if the type of your ACPs and PVs are same?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
akhilan
over 11 years ago
Can you verify if the type of your ACPs and PVs are same?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data