Team, I have a database view already created. I am now trying to crea

Manikandan Ganapathy over 9 years ago

Team,

I have a database view already created. I am now trying to create a data type & data store in appian designer so that i can query the database using a!queryentity().

But it doesn't allow me stating that a_id is missing as it is the primary key. How i need to add this in the XSD file so that no new tables will be created?

Discussion posts and replies are publicly visible

Parents

0 Jacob Cohen - Project Leader - Macedon Technologies over 9 years ago

Here's a link to some documentation on creating your XSD:
forum.appian.com/.../Custom_Data_Types_from_XSD.html
Check out the "<xsd:element name="id" type="xsd:int">" tag for an example of a primary key definition.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Jacob Cohen - Project Leader - Macedon Technologies over 9 years ago

Here's a link to some documentation on creating your XSD:
forum.appian.com/.../Custom_Data_Types_from_XSD.html
Check out the "<xsd:element name="id" type="xsd:int">" tag for an example of a primary key definition.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data