how to get the nested CDT Data

Hi Kiran,

If you are trying to use empId as a filter in your query, but there is no empId in the documents CDT (even if the DB table has the EMP_ID column), you will get this error message. If you add the empId field to the document CDT, the query should work fine. If you are trying to get information from the employee cdt by going through the document table first, I would recommend creating a DB view that has the relevant fields from both the document CDT and the employee CDT. Then you can create a query to call that view and query with both doc information and employee information and return both doc and employee info. using a!selection() in the query entity can also help you only pull back certain fields from the query if you wanted to do something like returning only employee fields, so the datasubset is structured like the employee cdt.

Hope this helps,
Alex

It would probably be much more efficient to go the route of creating a view. Most DBMS implementations are much faster at joining data sets than Appian is. Do all your joins in the database to get your view. Only use Appian to query the view.

It would probably be much more efficient to go the route of creating a view. Most DBMS implementations are much faster at joining data sets than Appian is. Do all your joins in the database to get your view. Only use Appian to query the view.