Can a composite key be used for Appian CDTs?

Using a composite key for Appian CDTs (Complex Data Types) is indeed possible, but there are limitations associated with certain functionalities. A composite key is defined as a key that consists of two or more attributes that uniquely identify a record in a database. This can be helpful for ensuring data integrity and uniqueness when working with more complex data structures.

However, while Appian allows the use of composite keys, it does not support all operations seamlessly when such keys are utilized. Certain functionalities, such as certain query operations or integrations might not work as smoothly with composite keys as they would with single primary keys. This means that developers should be aware of these limitations and consider whether the benefits of using composite keys outweigh the potential challenges in managing them.

The other choices suggest that composite keys are either not supported at all or discouraged, which is not the case since they are indeed supported with some considerations to keep in mind.