News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) How to give alias to a...

Microsoft Dynamics AX (Archived)

How to give alias to an aggregate field.

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Hi,

How can I add an alias to an aggregate field.

Following is my code sample:

while select BrandName, count(RecId) from brandsTable
join BrandRecId, ProductName from productsTable
group by brandsTable.BrandName
where brandsTable.RecId == productsTable.BrandRecId
{

.........
}

I want to give an alias to count(RecId):

Thanks,

Tauseef.

*This post is locked for comments

All responses Img

All responses (3)

Answers Img

Answers (1)

Community Member Microsoft Employee on at

Like (1)

Report

RE: How to give alias to an aggregate field.

Thanks Faisal and Crispin.

Sorry for my stupid questions.

Actually its been 8 years now I am working on .NET and SQL.

And I am totally new to AX 2012.

So, sometimes my mind automatically tends to compare the two.

So don't mind.

Thanks a lot.
Verified answer

Faisal Fareed 10,794 User Group Leader on at

Like (0)

Report

RE: How to give alias to an aggregate field.

Hi Tauseef,

X++ does not have all the functions available of SQL queries so please don't expect you can do everything in AX which is possible in SQL.
Community Member Microsoft Employee on at

Like (0)

Report

RE: How to give alias to an aggregate field.

Thanks a lot Crispin.

That's what I have used in my while loop and it is giving me the desired result.

But I was curious to know is there anything like alias in X++ select query.

Thanks.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans