Question
WillisTowerWatson
US
Last activity: 27 Nov 2024 16:23 EST
duplicate values when we try to filter data on a table
Hi, We customized the report filter criteria based on our business requirements and displaying those results in a table grid .But we are seeing multiple values Can you please let me know how to resolve this issue . Same problem mentioned this post .https://support.pega.com/question/duplicates-report-filter
Thanks,
Rashmitha
***Edited by Moderator Rupashree S. to add Capability tags***
Accepted Solution
Updated: 27 Nov 2024 16:23 EST
WillisTowerWatson
US
@thulg this solution worked for me https://support.pega.com/discussion/filter-issue-repeating-grid-showing-double-values-filter but the HotFix is for 7.2 not sure if we have any hotfix for 8.6.Removing the dynamic layout and keeping the table outside resolved the issue .
Pegasystems Inc.
IN
@RashmithaM This can happen if there are additional spaces in the values of the column being filtered. For instance, if a column has the same value across multiple records but includes leading or trailing spaces, it may appear as separate filter values. To resolve this, ensure that there are no extra spaces in the data being used for filtering. Additionally, if multiple tables are configured with the same source, applying filters in one table may affect the records displayed in others, leading to unexpected results.
Accepted Solution
Updated: 27 Nov 2024 16:23 EST
WillisTowerWatson
US
@thulg this solution worked for me https://support.pega.com/discussion/filter-issue-repeating-grid-showing-double-values-filter but the HotFix is for 7.2 not sure if we have any hotfix for 8.6.Removing the dynamic layout and keeping the table outside resolved the issue .