Query duplicated records from List view for query string in UI Builder

[Tadz]

Hi Guys,

Is there a quick way to get duplicated records in list view?

For example:

I want to get all records with duplicated short description.

Or do we have to create a script to get these?

Reason is, i'm trying to get the query string to apply it in a UI Builder query.

Thanks,

Tads

[Musab Rasheed]

Hello,

Easiest thing would be to do 'Group by' on Short description , You will easily come to know right ?

Regards

[Mark Manders]

You can right-click on the text in the field and select 'show matching'. If you just want to check on duplicates, you will need to script.

If my answer helped you in any way, please then mark it as helpful.

Mark

[Tadz]

Sorry, I didn't expound my question property.

Reason is, i'm trying to get the query string to apply it in a UI Builder query. 

So doing groupby and show matching will not work.

[Tadz · Accepted solution]

I think I found a solution, I create a Aggregation Query and grouped by Name.

Then in order to fit it in a query string I created a Data Transform to get the following results

Example "NameINTest,Qwerty".