Skip to main content

Hi Everyone,

 

In Generic Inquiry, is this possible to get the duplicate records count just like below sample SQL query.

 

SELECT username, email, COUNT(*)
FROM users
GROUP BY username, email
HAVING COUNT(*) > 1

Hi @naveenb74 

You won’t be able to o the “HAVING COUNT(*)>1” part in Generic Inquiries, but if you have the count as one of the columns in the results of your inquiry you can filter at the column level.

I don’t have duplicate e-mail addresses in my Users table so I used another table to try out what you’re asking and built a generic inquiry that shows me the count of invoices by customer.

 

And the column filter:

 

Thanks a lot, @Gabriel Michaud. This will help us.

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved