Question
Estes Forwarding Worldwide
US
Last activity: 31 Oct 2022 12:57 EDT
Composite key does not work when using savable list
I've created a data type with a system of record and two primary keys (composite key). When I enter records through the records tab of the data type, I'm able to enter new records as long as one of the keys are unique. When I use associated savable page however, the same records are unable to be saved. Saving through the savable page requires that both keys be unique. The composite key is not working when saving records through activities (Call Save)
Why is the behavior different when saving new records through an activity as opposed to through the records tab? How can I remedy this?
I'm trying to prevent duplicate records from being inserted into the SOR.
Accepted Solution
Updated: 31 Oct 2022 12:57 EDT
Estes Forwarding Worldwide
US
@DevinD16607791After doing some research, I think the reason for the behavior could be that I had updated the primary key after data type creation.
The following post explains that changing the key in the class does not automatically change the primary key in the DBMS
https://support.pega.com/discussion/how-change-key-data-type
However, I was still able to add records with a unique composite key on the records tab, but not through an activity... is there any logic behind that?