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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / The Dynamics 365 Library / Building query AND using qu...

Building query AND using query object in X++

Faisal Fareed Profile Picture Faisal Fareed 10,796 User Group Leader
Create and add datasource with range in X++
// Code using X++ to build the query
Query query;
QueryRun queryRun;
QueryBuildDataSource qbds;
ProjTable ProjTable;
;

query = new Query();
// Add a datasource to the query
qbds = query.addDataSource(tableNum(ProjTable));
// Add a range to the newly added datasource.
qbds.addRange(fieldNum(ProjTable, ProjId)).value("00403_1036..00412_1036");

queryRun = new QueryRun(query);

while(queryRun.next())
{
projTable = queryRun.get(tableNum(ProjTable));
info(projTable.ProjId + ", " + ProjTable.Name);
}



Use query object to retrieve AOT query
// Code using a query string
static void UseAOTQuery(Args _args)
{
Query query;
QueryRun queryRun;
QueryBuildDataSource qbds;
QueryBuildRange qbr;
ProjTable projTable;

query = new query(queryStr(ProjTable));
queryRun = new QueryRun(query);

while (queryRun.next())
{
projTable= queryRun.get(tableNum(ProjTable));

info (strFmt("%1 - %2", ProjTable.ProjId, ProjTable.Name));
}
}

This was originally posted here.

Comments

*This post is locked for comments