I want to display data in single record type from multiple tables
Discussion posts and replies are publicly visible
Hi Shoaib
Can you please download the xsd of your CDT and check whether @entity annotation refers to the same view which you have created in DB or not.
Also if this doesn't work, try downloading the DDL script from Data store entity design object and check the view name it's going to create and check whether this name and your view name matches or not.
Also make sure, you have created the view under the same schema which is linked to your data store entity design object.
Still if you are unable to resolve this issue, I recommend, please upload your CDT here as well as your View name ( AVAILABLE in DB) so that practitioner can help you to resolve this issue.
Also make sure, you have defined any one of the field of your CDT field as Primary key (but not Auto Increment) otherwise, while publishing the data store it will create a column named as Id (Primary key)
Hope this helps.
Can you please attach the screenshot of your record configuration as well as your CDT structure so that it will be easy to understand the root cause.