Question
Aegis Insurance
IN
Last activity: 9 Jan 2017 15:26 EST
Dropdown unable to use SQL function field from Report Definition
I have sourced a Dropdown using a RD. In the RD, one of the fileds uses the concatenate function. When the RD is run standalone it runs fine and returns the expected data.
If I try to use the concatenated RD property in the Dropdown, Pega throws errors and is NOT allowing to configure the concatenated property on the dropdown.
Below is the RD output.
In the dropdown control in the section, the RD columns shows up as below.
But after we select the column, click on OK and then try to save the section, the below errors gets thrown.
Pasting errors below for easier reading
I have sourced a Dropdown using a RD. In the RD, one of the fileds uses the concatenate function. When the RD is run standalone it runs fine and returns the expected data.
If I try to use the concatenated RD property in the Dropdown, Pega throws errors and is NOT allowing to configure the concatenated property on the dropdown.
Below is the RD output.
In the dropdown control in the section, the RD columns shows up as below.
But after we select the column, click on OK and then try to save the section, the below errors gets thrown.
Pasting errors below for easier reading
Test compilation failed: ----------
1. ERROR in Rule_HTML_Section_XXXX_SeverityCodes_Stream_20161220T070942_347_GMT.java (at line 493)
tools.appendString(pega_uiengine_formatter.pxFormatText(pega_uiengine_pzcontrol.pzGetCaptionValue("reportdefinition","XXXX-SeverityCode","GetSeverityCode:$","","","",".@@pxConcatenate(.SEVERITY_CODE,.SEVERITY_DESC,"-")",".SEVERITY_CODE",false,(PegaStreamAPI)tools),false,"","",false,"caption"));
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
The operator - is undefined for the argument type(s) java.lang.String, java.lang.String
----------
2. ERROR in Rule_HTML_Section_XXXX_SeverityCodes_Stream_20161220T070942_347_GMT.java (at line 494)
if("".equals(pega_uiengine_pzcontrol.pzGetCaptionValue("reportdefinition","XXXX-SeverityCode","GetSeverityCode:$","","","",".@@pxConcatenate(.SEVERITY_CODE,.SEVERITY_DESC,"-")",".SEVERITY_CODE",false,(PegaStreamAPI)tools)) && pzAuto.getBrowserUtils().isIE() && !pega_uiengine_harness.pzInStandardsMode()){
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
The operator - is undefined for the argument type(s) java.lang.String, java.lang.String
----------
3. ERROR in Rule_HTML_Section_XXXX_SeverityCodes_Stream_20161220T070942_347_GMT.java (at line 580)
displayString = cbpRow.getStringIfPresent(".@@pxConcatenate(.SEVERITY_CODE,.SEVERITY_DESC,"-")");
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
The operator - is undefined for the argument type(s) java.lang.String, java.lang.String
----------
3 problems (3 errors)
***Updated by moderator Maryrita: Moved to Product Support from Upgrade Center***
Pegasystems Inc.
US
Vivek,
I believe the problem is that the result of @@pxConcatenate isn't actually a property. I've found an internal discussion about a very similar issue reported in PRPC 6 and the response was:
"Calculations created in Report Definitions are internally stored as @@funcionname(params).
As there is no physical property that they get assigned to, the dynamic select is unable to support the functions."
I can't 100% confirm that this is still unsupported, but it certainly looks that way.
Could you try sourcing the dropdown from a list that's populated by your report definition (or some other similar solution where you use an intermediary to store the concatinated values in an actual property)?