How to Use Group By in select statement in AX 2009 using X++?
This is the way to use group by in select statement in X++ code for Example:
while select ph group by ph.PATIENT_TP_REFNO where ph.ACCOUNT_NO==AccountNo.text()
while select ph group by ph.PATIENT_TP_REFNO where ph.ACCOUNT_NO==AccountNo.text()
Comments
from inventItemBarcode group by ItemId
where inventItemBarcode.blocked == 1