What is the equivalent of HAVING clause in AX2009 query?

Finance and Operations/AX Developer Forum
1

Hello,

Does anyone know a workaround on how to have the equivalent of HAVING clause in an AX2009 query? I know AX2012 already has this functionality but is there anyone who’s successful in doing this in AX2009?

For example, I want with the same result as this SQL statement:

SELECT ItemGroupId, COUNT() FROM INVENTTABLE
GROUP BY ItemGroupId
HAVING COUNT() < 100

Is there a way to do this?

Thanks in advance!

2

please check the below link

http://www.axaptapedia.com/Having_Clause