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 neelimaj over 9 years ago

Define a primary key to the cdt xsd file using @id to define primary key.. If you do not define any primary key.. Appian automatically creates a primary key with name a_id.. Remove the previous table and publish the xsd again with primary key defined..
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 neelimaj over 9 years ago

Define a primary key to the cdt xsd file using @id to define primary key.. If you do not define any primary key.. Appian automatically creates a primary key with name a_id.. Remove the previous table and publish the xsd again with primary key defined..
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data