Unable to use report definition to pass PrimaryKey
I have configured a savable data page, which takes values from pyWorkPage, pyOperatorID. The goal is to overwrite a row in the dataset. I have configured a report definition which takes user entered data (on pyWorkPage) and looks up the value of the Primary Key (unique key.) I have been unsuccessful in passing any value through, and the savable data gives an error as UniquieID = NULL.
In order to do proceed, I have configured another drop down where the user must select the Unique Key during the case action. This saves the key to the pyWorkPage which I can then pass through to the savable datapage as param.
1) Is it possible to directly pass the results of a report definition to the savable data page Paramater for UniqueKey
2) If not, is it possible to configure a hidden text which will be used to store the data on the pyWorkPage?
I have tried using the following Property for the Text Cell. D_PageMadeWithReportDefinition[k1:pyWorkPage.k1,k2:pyWorkPage.k2].pxResults(1).PrimayKey but this does not work
Accepted Solution
Updated: 23 Jun 2022 11:16 EDT
IQZ Systems LLC
US
@AhsanK80 Hi,
Try using function to retrive the Dpage value and the required property value.
@(Pega-ProCom:RuleManagement).getPropertyValue(@(Pega-RULES:Property).getPageValue(D_PageMadeWithReportDefinition[k1:pyWorkPage.k1,k2:pyWorkPage.k2].pxResults(1)), ".PrimayKey")
Also make sure you pyWorkpage has the value for k1 and k2 before calling this.
Updated: 23 Jun 2022 11:16 EDT
JP Morgan Chase & Company
US
@KiruthikaA Hello, Thanks for this. I entered this into the Data Transform needed for the Database Save option in order to update the PrimaryKey. It is working