suitescript - How to remove duplicates results from Custom Record Saved Search in NetSuite

Question

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.

question from:https://stackoverflow.com/questions/65953100/how-to-remove-duplicates-results-from-custom-record-saved-search-in-netsuite

Answer 1

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.