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

Community site session details

Session Id :
Dynamics 365 Community / Blogs / DaxGeek / Building a Query in X++

Building a Query in X++

Views (142)
Hossein.K Profile Picture Hossein.K 6,648
Queries contain many important elements. These elements have been discussed
in earlier courses in the context of the AOT. This section discusses these
elements from within the context of X++. Elements include datasources, ranges,
and sort fields which build upon each other.
There are two more classes to note before building a query:

• QueryBuildDataSource

• QueryBuildRange

QueryBuildDataSource

Data sources are what queries are built upon. They are arranged in a hierarchy
and define the sequence in which records are fetched from tables assigned to the
data source. The following example adds a data source to a query using X++: 


1
2
3
Query query = new Query();
QueryBuildDataSource qbds =
query.addDataSource(TableNum(SalesTable));

Notice that the data source is an object, but the query object, 'query', requires a
method to add this data source to the query and assign the SalesTable to the data
source.

QueryBuildRange
A QueryBuildRange object is embedded within a data source of a query and
defines which records should be selected from the data source. A querybuild
range is built upon a QueryBuildDataSource object. The following example
uses the QueryBuildRange: 


1
2
3
4
5
Query query = new Query();
QueryBuildDataSource qbds =
query.addDataSource(TableNum(SalesTable));
QueryBuildRange qbr =
qbds.addRange(FieldNum(SalesTable,CustAccount));

Best Regards,
Hossein Karimi

Comments

*This post is locked for comments