I have some doubts regarding the mapping among "DB-> CDT-> Query Rule

mjayaswal over 9 years ago

I have some doubts regarding the mapping among "DB-> CDT-> Query Rule"
1). Can we map a CDT to existing database table which does not have any primary key defined? (I cannot modify the existing tables and the tables don't have primary keys defined. I tried but it does not allow to map if the Primary Key is not there)

2). Can we map a CDT to SQL function and use it to retrieve the data from function? (I guess we cannot)...

Discussion posts and replies are publicly visible

Parents

0 Tim
Certified Lead Developer
over 9 years ago

1) Yes this is possible, the underlying database table does not need to have a primary key defined at the DB level however you must annotate one column using the @Id jpa annotation. I would hope that the table does have some level of unique-ness so choose the appropriate column for this. If your column does not contain unique data then you will not see the full resultset when using query rules.
2) This may depend on your RDBMS, in Oracle for example you can define function based columns in both tables and views which can be mapped to appian datatypes
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Tim
Certified Lead Developer
over 9 years ago

1) Yes this is possible, the underlying database table does not need to have a primary key defined at the DB level however you must annotate one column using the @Id jpa annotation. I would hope that the table does have some level of unique-ness so choose the appropriate column for this. If your column does not contain unique data then you will not see the full resultset when using query rules.
2) This may depend on your RDBMS, in Oracle for example you can define function based columns in both tables and views which can be mapped to appian datatypes
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data