Question
Labb Consulting
PH
Last activity: 22 Feb 2023 14:28 EST
Duplicate report definition result when using "contains"
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?
***Edited by Moderator Marije to change type from General to Product, added Product details and Capability tags****
Accepted Solution
Updated: 22 Feb 2023 9:51 EST
Labb Consulting
PH
Will be closing this one as the issue was due to our own record in the DB. Sorry.
Pegasystems Inc.
IN
@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
Labb Consulting
PH
@SrinidhiMhello, unfortunately we dont have an ID column so the suggested solution is currently not available but will consider adding this one. thanks.
Accepted Solution
Updated: 22 Feb 2023 9:51 EST
Labb Consulting
PH
Will be closing this one as the issue was due to our own record in the DB. Sorry.
