Dynamics Community Forum Thread Details

X++ query bug with order by

An unpleasant discovery with some inherited code today.

This block of code does not order results as expected because the field used does not exist, it does however compile without issue.

str lineDisc = 'Disc.';
date curDate = DateTimeUtil::getSystemDate(DateTimeUtil::getUserPreferredTimeZone());

PriceDiscAdmTable priceDiscAdmTable;
PriceDiscAdmTrans priceDiscAdmTrans;

while
	select priceDiscAdmTable
		order by priceDiscAdmTable.ModifiedDateTime desc // ***THIS FIELD DOES NOT EXIST***
		where (PriceDiscAdmTable.Posted == 1)
	join priceDiscAdmTrans
		where (priceDiscAdmTrans.JournalNum == priceDiscAdmTable.JournalNum) && (priceDiscAdmTrans.ItemRelation == lineDisc) && (PriceDiscAdmTrans.FromDate <= curDate) && (PriceDiscAdmTrans.ToDate >= curDate)
{
	discounts.addEnd(priceDiscAdmTrans);
}

the intended code

str lineDisc = 'Disc.';
date curDate = DateTimeUtil::getSystemDate(DateTimeUtil::getUserPreferredTimeZone());

PriceDiscAdmTable priceDiscAdmTable;
PriceDiscAdmTrans priceDiscAdmTrans;

while
	select priceDiscAdmTable
		where (PriceDiscAdmTable.Posted == 1)
	join priceDiscAdmTrans
		order by priceDiscAdmTrans.ModifiedDateTime desc // ***THIS FIELD DOES EXIST***
		where (priceDiscAdmTrans.JournalNum == priceDiscAdmTable.JournalNum) && (priceDiscAdmTrans.ItemRelation == lineDisc) && (PriceDiscAdmTrans.FromDate <= curDate) && (PriceDiscAdmTrans.ToDate >= curDate)
{
	discounts.addEnd(priceDiscAdmTrans);
}

Categories:

Dynamics 365 Finance

Microsoft Dynamics AX

Quick Links