Does the syntax changes if you are using a database "view" as apposed

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 Reply Children
No Data