What is best practice while creating CDT? Is it better to have all data in one CDT or divide into multiple CDT (without nested CDT) where possible?
In addition to the above suggestions, refer the following links:
https://community.appian.com/w/the-appian-playbook/967/an-introduction-to-query-optimization (CDT/Table Design Steps Section)
AFAIK, for storing a list of values like Status, constants can be used. Also, the labels for components can be saved in constants. When there is collation of data, constants won't be of much help. In that case, Reference Table can be used.
For example, a list of all the Branches in Engineering in a certain university can be displayed using a constant. In the real time, every Branch has an HOD, a SPOC etc., In order to store all this data, a Reference or a Master Table will be of more help than a constant.
Hope this helps!!!
Discussion posts and replies are publicly visible
© 2020 Appian. All rights reserved.