Lets suppose that you have the typical 3 tables (customer, order and orderitem)

JEAN PIERRE over 11 years ago

Lets suppose that you have the typical 3 tables (customer, order and orderitem) in a relational database.
The relationship between these tables are the following:
One to many between customer and order
One to many between order and orderitem
Now you define a CDT for the customer entitiy with all its properties (table columns) including the related order entity.
Question:
If you instantiate a specific customer with its CDT the system will return from the database all the related orders and recursively all the related orderitems?
This could be a lot of data and very inefficient.
...

Discussion posts and replies are publicly visible

0 Stefan Helzle
A Score Level 3
over 11 years ago

Did you have a look at the reference application? There is a type SALES_Order and a type SALES_Order_Withoutitems. Both map to the same tables in the DB.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 JEAN PIERRE over 11 years ago

Yes, we have installed the Appian Reference App.
And as we saw these two CDT pointing to the same table our question emerged.
Returning to our question, can you confirm that instantiating a customer would return all the data recursively?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Stefan Helzle
A Score Level 3
over 11 years ago

Yes
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 JEAN PIERRE over 11 years ago

Wow! Now we understand...
Thank you very much for your advice!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel