I am creating a saved search on a custom record to show all the records, but when I preview the saved search many duplicate records are being displayed on the screen. How can I eliminate the duplicates? And I don't want to remove all my Saved Search columns as when i used summary type as Group that time unique results were coming but all columns were not coming.
Asked
Active
Viewed 2,507 times
-1
-
In the saved search results, are you joining data from Transactions ? – B. Assem Jan 31 '21 at 16:33
-
Yes in results i'm showing transactions that is sourcing from custom record's field – Mr. Kamran Feb 01 '21 at 04:06
-
Then unless you need data from the Transaction line (like the Item on each line), you can remove the duplicated lines by filtering on the Transaction Mainline = True – B. Assem Feb 01 '21 at 16:34
1 Answers
0
You need to add summary type to the "missing" columns as well.
When you have summary type for some fields, those without summary type will not show on the results by default. You will see them only when you click the link from one of the grouped columns.

Jala
- 889
- 4
- 9