How to Used Order By and Group By Clause in x++ Language when joins four table or more table......

(0) Share

Report

Posted on by Vikas_AX_Blogs

875

Anyone cal tell me how to use Order By and Group By Clause in score table on marks .Field of score table is score1,socre2,score3 like

static void CXT_Joins(Args _args)
{
CXT_Student stud;
CXT_ContacInformation contact;
CXT_Location location;
CXT_Score score;
int k=0;
;
while select stud
join score
where stud.Cxt_Stud_Id==score.Cxt_Stud_Id
join location
where stud.Cxt_Stud_Id==location.Cxt_Stud_Id
join contact
where stud.Cxt_Stud_Id==contact.Cxt_Stud_Id
info("Hi Number has inserted");
info(strFmt("Id Is=%1---Score1 Is=%2---Score2 Is=%2----Score3 Is=%3---Location Is=%4---Mobile No Is=%5",stud.Cxt_Stud_Id,score.Score1,score.Score2,score.Score3,location.Location,contact.ContactPersonPhone));

}

*This post is locked for comments

All responses (4)

Answers (2)

Verified answer

Martin Dráb

234,035 Most Valuable Professional on at

Like (0)

Report

RE: How to Used Order By and Group By Clause in x++ Language when joins four table or more table......

Vikash, please let me quote the documentation of select statement syntax (already linked above).

Keyword	Description	Example
asc	An option on the order by or group by clause. The sorting is ascending. (Sort is ascending by default.)	select * from custTable order by Name asc;
desc	An option on the order by or group by clause. The sorting is descending.	select * from custTable order by Name desc;

Seriously, you won't become a developer if you don't learn how to use documentation.

Community Member on at

Like (0)

Report

RE: How to Used Order By and Group By Clause in x++ Language when joins four table or more table......

Hi Vikas,

Can you please explain with example about how is your data in the tables and what results you want based on that?
Vikas_AX_Blogs 875 on at

Like (0)

Report

RE: How to Used Order By and Group By Clause in x++ Language when joins four table or more table......

Hi Martin Sir

i am beginner in AX and its only for practice. I want to arrange Score in Ascending and descending format so how to apply order by clause in this x++ Code.
Verified answer

Martin Dráb 234,035 Most Valuable Professional on at

Like (0)

Report

RE: How to Used Order By and Group By Clause in x++ Language when joins four table or more table......

The syntax is documented, unsurprisingly, in Select Statement Syntax [AX 2012].

You also have to realize that if you group records, you'll get values only those fields that are either grouped by or are aggregated (using aggregation functions such as sum() and maxOf()). You said that you want to group by Score1, Score2 and Score3, but you're also returning Cxt_Stud_Id, Location and ContactPersonPhone. You have to decide what to do with these fields.

Community site session details

How to Used Order By and Group By Clause in x++ Language when joins four table or more table......

Helpful resources

News and Announcements

Quick Links

Jainam Kothari – Community Spotlight

Congratulations to the May Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard >

Featured topics

Product updates

Community site session details

How to Used Order By and Group By Clause in x++ Language when joins four table or more table......

Helpful resources

News and Announcements

Quick Links

Jainam Kothari – Community Spotlight

Congratulations to the May Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard >

Featured topics

Product updates