Notifications
Announcements
No record found.
hi,friends
,I have one table like this. I want select some data group by teststringid and count(teststringid)>2,use ax code,could you help me ?
*This post is locked for comments
Hi,
Refer below link
http://www.axaptapedia.com/Having_Clause
hi，friends ,I want get some data like teststringgrade>60 && count(teststringid)>=2,could you help me?
Do you want to do that by coding or do you just want to filter transactions?
Best regards
Ludwig
Hi Marin,
Please refer link below and see section ... Group by and order by..
docs.microsoft.com/.../select-statement-examples
hi，Vignesh ，thanks your replay，but maybe there are not Having in the X++
hi，Friends ，I want by code
Although there is no Having in AX, you can use Query () to achieve the conditions you need.Vignesh's shared article, in fact, has talked about this part, you can read it carefully.
http://www.axaptapedia.com/Having_ClauseAn example of AX2012:https://community.dynamics.com/ax/b/dynamicsaxsolutions/posts/how-to-use-having-in-ax-2012
I hope it will help you.
hi，friends ，I copy everything from fitst page ，but it show error：My_FiledID uninitialized,and Second link QueryHavingFilter havingFilter this one is not suit dynamicx ax 2009,I am a new bird,I really thanks your reply.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 4 Most Valuable Professional
Priya_K 4
MyDynamicsNAV 2
,I have one table like this. I want select some data group by teststringid and count(teststringid)>2,use ax code,could you help me ?
