How do we map a CDT to a database view??/ Any documentation related to vie

Question

How do we map a CDT to a database view??/
Any documentation related to views & CDT is very helpful.
We tried creating a CDT with annotations but it creates a table in the DB. Is there any extra anootations / tags we need to take crae for views. We have created a view in the database in MS SQL....

colton.beck · Answer

Hi, Raghu. A couple things.

If the table name is different from the CDT name, add an @Table(name = "<tableName>").
If any CDT field names are different from the table column names, add an @Column(name = "<tableColumnName>").
If one of your CDT fields should be a primary key, add an @Id annotation to that field in the CDT.
If your primary key should be autogenerated, add an @GeneratedValue annotation that that field in the CDT.

Hope this helps!

colton.beck · Answer

Here's an example of how you would use each of these: @Table(name="testdatatype") @Id @GeneratedValue @Column(name="test_datatype")

ankita0004 · Answer

Can you check the datasource in datastore I think you created the view in different database and now trying to map this on different database

ankita0004 · Answer

You have put a primary key in it by @Id annotation and the database view will have atleast 1 non null unique column @Table(name="Test") @Id @Column(name="Id", columnDefinition="int")