Hi,
I have created a view by joining 2 tables in our Appian cloud Database. I have created a cdt with the fields we have in view.
As we don't have primary key, i have made the primary key of one of the tables used in view as the primary key in cdt by using @Id annotation in XSD.
I have also used, @Table, @Column annotations in the XSD.
But while verifying the entity by mapping with this cdt, it is not getting verified and throwing the error "No matching tables found".
Please suggest a solution for this.
Regards,
Divya
Discussion posts and replies are publicly visible
Hi, You can add one more column in database view with definition
`rownum`() AS `id`
and map this field with CDT @Id annotation
Hi Divya,
Can you share the CDT xsd where table annotation is defined and the screenshot of the view from your db?