duplicate values when we try to filter data on a table

General
, , , , ,
1

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 .Duplicates in Report filter | Support Center

Thanks,

Rashmitha

2

@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.

3

@thulg this solution worked for me Filter issue on Repeating Grid, Showing double values on the filter. | Support Center 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 .