News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... X++ using maxof and mi...

Finance | Project Operations, Human Resources, ...

Suggested answer

X++ using maxof and minof in the same sql statement

(0) Share

Report

Report

Posted on by JauB

350

Hi Everybody

How can we use at the same time minof and maxof in one sql statement ?

like doing select maxof(AccountingFate), minof(AccountingDate) from .... ?

All responses Img

All responses (5)

Answers Img

Answers (0)

Suggested answer

Julian G 10 on at

Like (0)

Report

RE: X++ using maxof and minof in the same sql statement

You're welcome, just let me know if you need more help..
Suggested answer

JauB 350 on at

Like (0)

Report

RE: X++ using maxof and minof in the same sql statement

Thanks Julian for your suggestion
Suggested answer

JauB 350 on at

Like (0)

Report

RE: X++ using maxof and minof in the same sql statement

Yes that's why I did, but wished to do it proprly .. !

Thanks
Suggested answer

Julian G 10 on at

Like (1)

Report

RE: X++ using maxof and minof in the same sql statement

Hi,

I have faced the same requirement and I achieved by creating a view with string computed column.

public static server str MinAccountingDate()
{
tableName viewName = tableStr(View);

return SysComputedColumn::min(SysComputedColumn::returnField(viewName, identifierStr(viewDatasourceTable) , fieldStr(viewDatasourceTable.AccountingDate)));

}

public static server str MaxAccountingDate()
{
tableName viewName = tableStr(View);

return SysComputedColumn::max(SysComputedColumn::returnField(viewName, identifierStr(viewDatasourceTable) , fieldStr(viewDatasourceTable.AccountingDate)));

}
Suggested answer

Mea_ 60,278 on at

Like (0)

Report

RE: X++ using maxof and minof in the same sql statement

You cant, result is saved into the field, so the easiest way is to do 2 select statements

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,149 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans