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(*) > 1Solved
Can we get a duplicate records count in Generic Inquiry
+19Best answer by Gabriel Michaud
Hi
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:
+11Hi
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.