I am running into a issue while trying to map a CDT to a Database view. Backgrou

I am running into a issue while trying to map a CDT to a Database view. Background is ,we had a view which selects records by joining multiple tables. While defining the CDT we had defined one of the columns with @Id JPA Annotations. Everything worked fine ,but as part of an ongoing enhancement we changed the view to have an additional table. When joining with this table ,the column which had @Id is no more unique ,it has duplicate values. We are using a query entity to return data from this view ,but with this @Id having duplicate values ,"totalCount" returned takes only the distinct values of this ID. This in-turn mess up our Grid ; I tried making composite primary key by defining some additional columns with @Id. It is also not working ,possibly because those columns are VARCHAR

OriginalPostID-172933

OriginalPostID-172933