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

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

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

Oops concept in AX

Class : Class is the 1st OOPs concept .Class defines the characteristics of objects which includes its attributes , fields  properties and behavior . Let us say we have a class called car , then the color , model number , top speed can be its attributes and properties . Accelerating , breaking , turning will be its behavior Objects: Objects can be considered as a thing  that performs a set of related functions .Programming objects are used to model real worlds objects. An object is also an instant of a class . For our class Car , Ferrari  will be our object Instance : One can have an instance of a class; the instance is the actual object created at runtime.  The set of values of the attributes of a particular object is called its state. The object consists of state and the behaviour that’s defined in the object’s class. Method :Also called as  functions in some programming languages , methods defines the  behavior of particular objects . For our Ca...
Read more