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
4 replies
Subscribers
7 subscribers
Views
1412 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Does the syntax changes if you are using a database "view" as apposed
robr
over 9 years ago
Does the syntax changes if you are using a database "view" as apposed to a "table" in a query rule?
I have a CDT based on a Database view. I created a data store from it. I then created a Query Rule. Everything seems to be fine so far.
I then user the Query Rule in a an express rule which looks like the following:
local!applicationRTOs: rule!getApplicationRTOs(ri!relationshipManagerIncentive_Int),
When I attempt to access via Tempo I get the following error:
Expression evaluation error in rule 'getapplicationrtos' (called by rule 'applicationrtodatafieldsui'): Error evaluating function 'queryruleexec' : Unexpected error executing query (type: [ApplicationRTOsViewDT6520], query: [getApplicationRTOs], order by: [[Sort[description asc]]], filters:[(relationshipMgrIncentive = TypedValue[it=1,v=31541])])
I have triple checked my syntax but I could still be wrong. I am using 7.4...
OriginalPostID-108776
OriginalPostID-108776
Discussion posts and replies are publicly visible
Parents
0
jesse.triplett
Appian Employee
over 9 years ago
Yes I only meant declare the PK in the CDT, which it appears was done. In the data in the view, is applicationRTO_ID unique or are there duplicate entries?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
jesse.triplett
Appian Employee
over 9 years ago
Yes I only meant declare the PK in the CDT, which it appears was done. In the data in the view, is applicationRTO_ID unique or are there duplicate entries?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data