Skip to main content

Hi All,

I wish to find duplicate rows from a custom object based on a field which is of external id type.

However, group by and having is not allowed on that field in soql.

Also in reports we can just group by using that field and can't apply having clause.

 

Due to large number of records we cant process it in excel either even if take simply export of all records.

 

Can anyone help or know of any workaround ?

2 respuestas