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
9 replies
Subscribers
5 subscribers
Views
3176 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
Issue with Query Database smart node
sswilliams
over 7 years ago
I get the following error in Appian when trying to do a select statement in the query database node a model (see attachement for the error message). My SQL Statement is:
SELECT PR_Reqr_id,PR_Reqr,PR_Reqr_phone,PR_Reqr_email
FROM Tbl_RequesterInfo
WHERE PR_Reqr_email = ac!requestorEmailAddress
I have another database node in the model with an insert SQL statement and no error is generated with this. Can someone help with this? Thanks…
OriginalPostID-234615
Discussion posts and replies are publicly visible
Parents
0
Colton Beck
over 7 years ago
I'd recommend refactoring this query as a query entity rule. If that's not an option, we can try to troubleshoot.
Are you referencing the table name using the correct case? How have you configured your AC? Are you using a pre-defined data source?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Colton Beck
over 7 years ago
I'd recommend refactoring this query as a query entity rule. If that's not an option, we can try to troubleshoot.
Are you referencing the table name using the correct case? How have you configured your AC? Are you using a pre-defined data source?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data