How to Use Group By in select statement in AX 2009 using X++?
Views (20971)
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()
Comments
-
how can i use group by and sum in x++ code, like I'm having a field called week in which weeks are repeating and other field is of capacity, i want to apply group by on week field and sum on capacity field, how can i do that?

Like
Report
*This post is locked for comments