Question

2
Replies
596
Views
VivekSasidharan_13 Member since 2016 2 posts
Aegis Insurance
Posted: December 22, 2016
Last activity: January 9, 2017
Closed

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

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***

Reporting User Interface
Moderation Team has archived post
Share this page LinkedIn