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

robr over 10 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...

Discussion posts and replies are publicly visible

Parents

0 robr over 10 years ago

I have a column I can use but I didn't think, within a database, I could identify a PK within a view. The XSD that creates the CDT has this in it:

@Table(name="ApplicationRTOsView")
</xsd:appinfo>
</xsd:annotation>
<xsd:sequence>
<xsd:element name="applicationRTO_ID" nillable="true" type="xsd:int">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
@Column(name="applicationRTO_ID", nullable=false)
@Id
@GeneratedValue
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 robr over 10 years ago

I have a column I can use but I didn't think, within a database, I could identify a PK within a view. The XSD that creates the CDT has this in it:

@Table(name="ApplicationRTOsView")
</xsd:appinfo>
</xsd:annotation>
<xsd:sequence>
<xsd:element name="applicationRTO_ID" nillable="true" type="xsd:int">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
@Column(name="applicationRTO_ID", nullable=false)
@Id
@GeneratedValue
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data