Case:
We need to bind column setup of some grid to package.
Implementation:
- Set up column setup and save this one for all users:
-
Go to DB and find key of SysProfileData record by query:
SELECT * FROM "SysProfileData" ORDER BY "ModifiedOn" DESC
-
Create new data binding in configuration section of bpm`online like below:
IMPORTANT!!! All checkboxes are VERY important. You should rewrite Data field in DB and merge SysProfileData record by Key, Contact and Culture fields.
When following this methodology in Freedom UI, when trying to install the data I get the following error message:
Duplicates data in object "SysProfileData".
Any info on why this would be happening? The update key is set to the 3 columns specified:
And the bound data is specified individually (rather than with a condition, as I don't think that's possible any more in Freedom UI) but the 2 records have different Keys:
It looks like adding "Object" (column SysUserId) to the update key of the data binding worked for me, but not sure if this will always work or is the recommended way to do things. It would be nice if Creatio could confirm whether this is the right way of binding column setup in Freedom UI.