We have a report definition that will fetch 2 columns. we filter using those 2 columns and will be using ‘contains’ as the relationship to make the search flexible. However, the results are having a duplicate value and the “Remove duplicate rows” is already enabled.
using the ‘is equals’ as the relationship solves the issue but would not satisfy the requirement.
Anyone knows how to solve this one?
@MikeHelene Hi Can you please try using the ID of the report class that you are using and check if you get duplicates? May be just include the id and hide from you UI. Please let us know
@SrinidhiM hello, unfortunately we dont have an ID column so the suggested solution is currently not available but will consider adding this one. thanks.
Will be closing this one as the issue was due to our own record in the DB. Sorry.
No apologies needed @MikeHelene!
Thanks for updating us and your Question!