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

Parents

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

Reply

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

Children

No Data