web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :

QueryBuildLink Class

Pooja Karki Profile Picture Pooja Karki 3,045

Today I will demonstrate you that how to use QueryBuildLink Class in AX.


static void querybuildlink_example(Args _args)
{
Query query = new Query();
QueryBuildDataSource custTableQBDS, custTransQBDS;
QueryBuildRange qbr1;
QueryBuildFieldList qbFl, qbF2, qbF3;
QueryBuildLink qbl;
QueryRun qr;
CustTable custTable;
CustTrans custTrans;
custTableQBDS = query.addDataSource(tablenum(custTable));
custTableQBDS.fields().dynamic(NoYes::No);
qbFl = custTableQBDS.fields().addField(fieldNum(CustTable, AccountNum));
qbF2 = custTableQBDS.fields().addField(fieldNum(CustTable, InvoiceAccount));
qbF3 = custTableQBDS.fields().addField(fieldNum(CustTable, CustGroup));
qbr1 = query.dataSourceTable(tableNum(CustTable)).addRange(fieldNum(CustTable, AccountNum));
qbr1.value(SysQuery::value('1102'));
custTransQBDS = custTableQBDS.addDataSource(tableNum(CustTrans));
custTransQBDS.relations(true);
qbl = custTransQBDS.addLink(fieldNum(CustTable, AccountNum), fieldNum(CustTrans, AccountNum));
qr = new QueryRun(query);
while (qr.next())
{
custTable = qr.get(tableNum(CustTable));
setPrefix ('Customer – ' + custTable.AccountNum);
custTrans = qr.get(tableNum(CustTrans));
info(custTrans.Voucher);
}
}

This was originally posted here.

Comments

*This post is locked for comments