Question
TCS
IN
Last activity: 11 May 2017 8:32 EDT
Report Definition - Filter not working
I had to use Replace function on one of the columns of Report Definition. But Filter is not working anymore. Does Replace function has any impact on filtering results?
Attaching the nested Replace function used.
Pegasystems Inc.
IN
Which version you are on ?
I tried in my local 7.2.2 and found that it is working fine.
Find the attached screenshot.
TCS
IN
I'm using version 7.2
Am suspecting the issue arise from replace function is because filter was working before. Attaching the screenshots.
TCS
IN
One more thing I've observed is that filter works if replace value has no space in it. i.e if values are ABC-4 , XYZ-5 then filtering is possible.
Accepted Solution
Pegasystems Inc.
IN
Hi Aparna,
There is an issue that even if the filter is selected it displays all the results when concatenate by space function is used.It works fine with other special characters like "_" or "," or "-".
There is a hotifx provided for this issue in 7.1.8 version but it works only when single checkbox in the filter is selected and does not work if the multiple checkboxes are selected..There is an enhancement request raised for this issue to get this fixed when the multiple checkboxes are selected in future release.
Enhancement ID:FDBK-18745
TCS
IN
Thank you for this information Sarab.