Appian show table has multiple primary keys

Question

Does anyone know why apprian would show that a table has multiple primary keys, when the table only has 1 primary key, 3 foreign keys and an alternate key?

Mike Schmitt · Accepted Answer

For now then you may be correct, in that you might be stuck using the Entity Data setup if you need to directly interact with that table from within Appian. 
 Additionally though, I'd urge you to open a support case with Appian specifying this use case, so they can get it in their product pipeline to perhaps cook up a way to either handle this case (or at least give developers the option to manually declare a 'main' primary key or some other override) so that you don't have to abandon the RecordType setup. I don't know how soon they might come up with some enhancement to handle that, but it'd be good for them to be aware of real-world use cases that prevent adoption.

Mike Schmitt · Answer

Would it be possible to alter the table and set it to only have 1 primary key? I'm unclear what the befit would be for having more than 1 defined. It wouldn't (afaik) affect your ability to have data stored in that second column or anything.

Appian show table has multiple primary keys

Top Replies