Hi,
I'm looking for examples on getting database data into a CDT with child CDT (nested). For example there is an order and a customer table. Each order has only one customer, i.e. one-to-one relationship.
I was reading the doc Custom Data Type (CDT) Relationships but still unsure of how to implement this. Also, what if there is no relationship setup between the order and customer tables in the database but I have access read-only access to both tables? Would it still work?
Thanks.
Discussion posts and replies are publicly visible
Hi Jude,
what you are not able to understand in the Custom Data Type (CDT) Relationships ? you need to create two CDT one will act as Parent (customer ) and other will as Child (order) . first create child CDT and then create Parent CDT and create one field in Parent CDT and set type as child CDT as suggested in the url. Now publish both CDT in data store.
When you will access the data from Parent CDT ( table) then child table data will automatically will come, you don't need to do anything from your side.
You can find how data store work follow this link : https://docs.appian.com/suite/help/18.3/Data_Stores.html
Let me know if you will face any issue.
Regards
Abhay