Solved

Can we get a duplicate records count in Generic Inquiry

  • 22 October 2020
  • 2 replies
  • 650 views
Naveen Boga
Rank
Userlevel 7
Badge +17

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
icon

Best answer by Gabriel Michaud 22 October 2020, 21:30

View original
Naveen B

2 replies

Naveen Boga
Rank
Userlevel 7
Badge +17

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

Naveen B
Gabriel Michaud
Rank
Userlevel 7
Badge +10

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:

 

Gabriel Michaud Founder @ Velixo, Excel-based reporting for Acumatica

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