How to: Create Query with Range through X ++


I had a hard time trying to find how use range between dates so I hope to help not only who wants to create a query but also who wants to know how to use range with date.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
// Create a new Job
static void CustDateRangeQuery(Args _args)
{
    Query                   query;
    QueryRun                queryRun;
    QueryBuildDataSource    qbds;
    QueryBuildRange         qbr;
    CustTable               custTable;
    ;
 
    // Instance the class Query
    query =  new Query();
 
    // Add DataSource to Query
    qbds = query.addDataSource( tableNum(CustTable));
 
    // Add a range
    qbr = qbds.addRange( fieldNum(CustTable,CreatedDateTime));
 
    // Set range value
    qbr.value(SysQuery::range( "01/01/2012","30/12/2012" ));
 
    // Run Query
    queryRun = new QueryRun(query);
 
    // Retrieves the next record from the query.
    while(queryRun.next())
    {
        // Get Result
        custTable = queryRun.get( tableNum(CustTable));
 
        // Show AccountNum
        info(custTable.AccountNum);
    }
}

Comments

Post a Comment

Popular posts from this blog

D365 – Data Entity Method Call Sequence

Image
  1. initValue 2. validateField 3. validateWrite 4. update 4.1. doUpdate 4.1.1. persistEntity 4.1.1.1. doPersistEntity 4.1.1.1.1. initializeDataSources 4.1.1.1.1.1. initializeEntityDataSource Note: initializeDataSource is called once for each DataSource in Entity. 4.1.1.1.2. mapEntityToDataSources Note: initializeDataSource is called once for each DataSource in Entity. 4.1.1.1.3. saveDataSources 4.1.1.1.3.1. updateEntityDataSource 4.1.1.1.4. mapEntityToDataSource (maybe for another record) 4.1.1.1.5. saveDataSources 4.1.1.1.5.1. updateEntityDataSource for update operation and (insertEntityDataSource for insert) 4.1.1.1.5.1.1. mapDataSourceToEntity 4.1.1.1.5.1.2. doSaveDataSource 4.1.1.1.5.1.2.1. updateDataSource 4.1.1.1.5.1.2.1.1. preupInsertDataSource 4.1.1.1.5.1.2.1.1.1. validateWrite of table Plus: postLoad This method is called during the export for setting the value to unmapped fields after entity is downloaded to datasource. EXPORT:        Entity- postLoad...
Read more

X++ code to create a customized lookup on form

Image
Override the lookup method on Formdatasource field(on which you want to show lookup) , and copy the following code to your method. Comment the super() method in the lookup. public void lookup(FormControl _formControl, str _filterStr) { SysTableLookup sysTableLookup; // systemclass to create //customlookup Query query; QueryBuildDataSource qbd; ; sysTableLookup = SysTableLookup::newParameters(tablenum(InventTable),_formcontrol); // Construct query on the table, // whose records you want to show as lookup. query = new Query(); qbd = query.addDataSource(tablenum(InventTable)); qbd.addRange(fieldnum(InventTable,ItemType)).value(SysQuery::value(enum2str (ItemType::Item))); // add the fields to the lookup list sysTableLookup.addLookupfield(fieldnum(InventTable,ItemId)); sysTableLookup.addLookupfield(fieldnum(InventTable,ItemName)); // pass the query as parameter // system will show the records in the lookup // as per your query sysTableLookup.parmQuery(query); sysTableLookup.performFormLo...
Read more

Dynamics Ax 2012 Interview Questions:

Interview Questions: 1.       Difference between following condel   :- Use condel to delete one or more items from a container. confind :- Use confind to locate a sequence of items in a container.  conins   :- Use conins to insert some items into a container. conlen   :- Use conlen to find out how many items there are in a container. connull  :- Use connull to explicitly dispose of the contents of a container. conpeek :- Use conpeek to extract an item from a container, and to convert it into another data type   conpoke :- Use conpoke to replace (poke) an item in a container. 2.       Difference between edit and display method Display  Indicates that the method's return value is to be displayed on a form or a report. The value cannot be altered in the form or report Edit  Indicates that the method's return type is to be used to provide information for ...
Read more