Contains Realtionship in Report logic is not working
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?
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).