What are the best practices for handling RDBMS table relationships. We usually c

What are the best practices for handling RDBMS table relationships. We usually create CDTs to map with our tables and in case there are multiple tables associated with each other we create nested CDTs.

My questions is more around mapping the inter related tables with nested CDTs using annotations with Lazy loading enabled. As Appian uses hibernate in the backend it should support lazy loading but I have seen whole object graph is fetched in process variables even if nested CDTs are configured as lazy loading enabled. In case lazy loading isn't supported in the process variables what are the best practice to model the nested CDTs in this case ?

Please let me know.

OriginalPostID-161380

OriginalPostID-161380