News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... wants to return latest...

Finance | Project Operations, Human Resources, ...

Answered

wants to return latest confirmdocnum form custinvoicejour with qbds query in ax 2012 r3

(0) Share

Report

Report

Posted on by @rp@n

6

hi all,

Dialog --

table - Cust Confirm Jour

my query --

public void executeQuery()
{
Query query;
QueryRun qrRun;

QueryBuildDatasource qbds;
QueryBuildRange qbr;

RecId chkRecid;

query = queryRun.query();

qbds = query.addDataSource(tablenum(CustConfirmJour));

// date range
qbr = qbds.addRange(fieldNum(CustConfirmJour,ConfirmDate));
qbr.value(queryRange(fromDate, toDate));

queryRun = new QueryRun(query);

while (queryRun.next())
{
custConfirmJour = queryRun.get(TableNum(CustConfirmJour));

chkRecid = custConfirmJour.RecId;
info(strFmt("%1",chkRecid));

}

i wants to return the latest confirmation doc num. means in the excel screen shot the BOLD marked recid should only return

Kindly let me know what line of code is required to add?

please give me more shed on this.

thanks!

}

All responses Img

All responses (3)

Answers Img

Answers (1)

@rp@n 6 on at

Like (0)

Report

RE: wants to return latest confirmdocnum form custinvoicejour with qbds query in ax 2012 r3

it's done
@rp@n 6 on at

Like (0)

Report

RE: wants to return latest confirmdocnum form custinvoicejour with qbds query in ax 2012 r3

why you removed date filter from query? it should be rite ?
Verified answer

udaY-ch 4,624 on at

Like (0)

Report
RE: wants to return latest confirmdocnum form custinvoicejour with qbds query in ax 2012 r3

Hi,

Try this code, if you haven't found already.

public static void queryGroup(Args _args) { Query query; QueryRun qr; QueryBuildRange qbr; QueryBuildDatasource qbds; CustConfirmJour custConfirmJour; query = new Query(); qbds = query.addDataSource(tablenum(CustConfirmJour)); //You should have these two lines to group the salesId and get the last reference. qbds.addGroupByField(fieldNum(CustConfirmJour, SalesId)); qbds.addSelectionField(fieldNum(CustConfirmJour, RecId), SelectionField::Max); qbr = qbds.addRange(fieldNum(CustConfirmJour, SalesId)); qbr.value(""); qr = new QueryRun(query); while (qr.next()) { custConfirmJour = qr.get(TableNum(CustConfirmJour)); info(strFmt("%1", custConfirmJour.RecId)); } }

Uday

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 293,278 Super User 2025 Season 1

#2

Martin Dráb 231,983 Most Valuable Professional

#3

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans