CODEWITHSUNDEEP
acumatica
Jerry Welliver
Jerry Welliver

Reputation: 377

BQL Duplicate detection

I need to write a BQL statement to select rows from SOOrder that are duplicated by 4 key fields. I want to select the duplicated rows for a processing page and allow the user to check the orders to delete. I have the page and all the logic prepared. I just need the BQL query to present the duplicates. Can someone give me a template query? I know I will need GroupBy and Aggregate.

Upvotes: 1

Views: 436

Answers (1)

Dmitrii Naumov
Dmitrii Naumov

Reputation: 1712

I think the easiest way to do this is to filter values with count<2 in select delegate. To show count in the grid you should just specify counted field in the grid. In your case it is SOOrder.orderNbr

Upvotes: 1

Related Questions