Skip to main content

ExecuteQuery code

ExecuteQuery code:

 
public void executeQuery()
{
    ;
    TECPOGroupHeader_ds.query().dataSourceTable(tableNum(TECPOGroupHeader)).clearRanges();
    if(statusFilter.valueStr() == enum2str(TEC_AllDraftPosted::Draft))
        TECPOGroupHeader_ds.query().dataSourceTable(tableNum(TECPOGroupHeader)).addRange(fieldnum(TECPOGroupHeader,Status)).value(sysquery::value(TECPOGroupStatus::Draft));
    if(statusFilter.valueStr() == enum2str(TEC_AllDraftPosted::Posted))
        TECPOGroupHeader_ds.query().dataSourceTable(tableNum(TECPOGroupHeader)).addRange(fieldnum(TECPOGroupHeader,Status)).value(sysquery::value(TECPOGroupStatus::Posted));
    //add by fanddy
    if(statusFilter.valueStr() == enum2str(TEC_AllDraftPosted::Confirmed))
        TECPOGroupHeader_ds.query().dataSourceTable(tableNum(TECPOGroupHeader)).addRange(fieldnum(TECPOGroupHeader,Status)).value(sysquery::value(TECPOGroupStatus::Confirmed));
    //END add by fanddy
    if(CreatorFilter.value() == true)
        TECPOGroupHeader_ds.query().dataSourceTable(tableNum(TECPOGroupHeader)).addRange(fieldnum(TECPOGroupHeader,CreatedBy)).value(sysquery::value(curUserId()));
    super();




CusTable_ds.query().dataSourceNo(1).sortClear();



CusTable_ds.query().dataSourceNo(1).addSortField(fieldNum(CustTable, AccountNum), SortOrder::Ascending);
CusTable_ds.executeQuery();








}







Sorting records



Sorting is the most important thing when display the data to the user. The user mostly prefers sorting functionality in the grid forms. AX 2012 has inbuilt functionality to sort the records in the grid by simply clicking the header of the grid column. Multiple sorting is not supported in the AX 2012. For example sort the fields by class and student name. Only single field sorting functionality is working in AX 2012.



As per the below example, we need to sort the record by student name. So, we should add some code in the form datasource init methd like below.







 







public void init()



{



    super();



    this.query().dataSourceNo(1).addSortField(fieldNum(Hari_ExamResult, StudentName), SortOrder::Ascending);



}








 








We can also clear the sorting functionality by calling the form datasource sortClear method like below.







void clicked()



{



    Hari_ExamResult_ds.query().dataSourceNo(1).sortClear();



    Hari_ExamResult_ds.executeQuery();



    super();



}







 







We should call the form datasource execute query to reflect the changes.







We can change the sorting field by using the below code.



First, clear the existing sorting field then add new sorting field.







void clicked()



{



    Hari_ExamResult_ds.query().dataSourceNo(1).sortClear();



    Hari_ExamResult_ds.query().dataSourceNo(1).addSortField(fieldNum(Hari_ExamResult, Standard), SortOrder::Ascending);



    Hari_ExamResult_ds.executeQuery();



    super();



}







 







We can use this code logic to achieve some sorting related business requirement













































Comments











Post a Comment























Popular posts from this blog



















Number sequence with existing module and new module




























  Number sequence customization in Dynamics 365   Create a number sequence in a standard module  Step 1: Create new EDT   Step 2: Add a new code block to the loadModule in the NumberSeqModuleXXX class   Step 3: Add a new static method to the parameters table of the module to get the number sequence reference    Using Extension  [ExtensionOf(classStr(NumberSeqModuleCustomer))] final class NumberSeqModuleCustTest_Extension  {  protected void loadModule()  {  NumberSeqDatatype datatype = NumberSeqDatatype::construct();  next loadModule();  datatype.parmDatatypeId(extendedTypeNum(TestId));  datatype.parmReferenceHelp(literalStr(‘Test ID’));  datatype.parmWizardIsContinuous(false);  datatype.parmWizardIsManual(NoYes::No);  datatype.parmWizardIsChangeDownAllowed(NoYes::No);  datatype.parmWizardIsChangeUpAllowed(NoYes::No);  datatype.parmSortField(1);  datatype.addParameterType(NumberSeqParameterType::DataArea, true, false);  this.create(datatype);  }  }   [ExtensionOf(tableStr(CustParameters...




















Post a Comment









Read more






























[D365/AX7] How to: Create and Use number sequence




























  [D365/AX7] How to: Create number sequence   Posted on January 7, 2018  Updated on January 11, 2018        Number sequences are used to generate readable, unique identifiers for master data records and transaction records that require identifiers. A master data record or transaction record that requires an identifier is referred to as a reference.  On this example, we are going to create a new number sequence for customer group.  Create a new class that extends the NumberSeqModuleCustomer  class and then create the method loadModule_Extension  and add the following code:  class NumberSeqModuleCustomer_CFS extends NumberSeqModuleCustomer {         public void loadModule_Extension()         {                 NumberSeqDatatype datatype = NumberSeqDatatype::construct();           ...




















Post a Comment









Read more






























Batch Multi threading D365FO AX7




























  Batch Multi threading D365FO AX7         Normally, when we schedule our RunBaseBatch class as a batch job, it will create single task. Which will responsible to execute complete process in single thread. But, As you know like AX-2009 and AX-2012. In D365FO We can add multiple AOS server in single batch group and they can process the multiple task simultaneously.  In this demo I will show, How to create multi threading Batch job. following are the steps Step-1 Create a table for demo purpose in our demo we keep table name is  SLD_DemoTable .   Step-2 create a class with name  SLD_DemoBusinessLogic  and write your business logic in this class. In demo I write only insert records in table and show you guys how it works.         Reference Code  class   SLD_DemoBusinessLogic   {          public   void  processInit( VendTable  _vend)       {            SLD_DemoTable  ...




















Post a Comment









Read more