Hi,
I am creating a view with union of two tables so this view doesn't have a primary key.
When i create CDT , appian creates a primary key and it says that a_id does not exist with the database .
Do you know how to resolve this situation ?
These are my plan
1) Add a_id to the view . This i have to do some research.
any ideas will help
Discussion posts and replies are publicly visible
Use ROWNUM and define this field as a primary key in cdt. SELECT ROWNUM as ID, <columns> FROM (select <columns> from <table1> union select <coulumns> from <table1> ); Your XSD: <xsd:element name="id_int" type="xsd:int"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@Id</xsd:appinfo> </xsd:annotation> </xsd:element>