Question
Virtusa Consulting Services Pvt. Ltd.
US
Last activity: 11 Mar 2016 6:41 EST
Contains Realtionship in Report logic is not working
Hi,
I have a report in which I am calling a sub-report on a condition. Now, I am trying to compare the value of a column in main report with another column of the sub-report in the filter logic of main report using relationship as Contains.
At run time, Pega is converting this condition into a wrong SQL statement. Its treating it as '=' relation.
Although, if we give a simple text value, it is treating at as LIKE condition. Any ideas?
Pegasystems
IN
1) Which version of Pega 7 is this?
2) Kindly share the details of the entire report including how the sub report has been configured. Better still, please give us the tracer XML when executing this report (please make sure enable DB Query in settings of the tracer).
Updated: 10 Mar 2016 4:32 EST
Virtusa Consulting Services Pvt. Ltd.
US
I am using 7.1.8
Main Report:
Data access tab of main report
Sub report
Configuration of sub-report in main report
I am using 7.1.8
Main Report:
Data access tab of main report
Sub report
Configuration of sub-report in main report
The tracer xml file is a 100MB file. I am not sure how to attach it Rajiv Nistala
Updated: 11 Mar 2016 6:41 EST
Virtusa Consulting Services Pvt. Ltd.
US
No Rajiv Nistala. I could not attach it. The portal is not responding when I am trying to attach it