Solved
Appian show table has multiple primary keys
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?
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.