Showing posts with label Filter data source. Show all posts
Showing posts with label Filter data source. Show all posts

Tuesday, December 28, 2021

Filter records in form in D365fo

Hi guys, Today we see how to filter the records in form using X++.

  • If it's a new form directly write the below code.
  •  If it's a standard form. create extension class.
Here we have 2 ways. Follow anyone.

Way 1:

    public QueryBuildRange qbr;//declare this variable globally. public void init()// dataSource init method { super(); qbr = this.query().dataSourceTable(tableNum(InventSite)).addRange(
                                                        fieldNum(InventSite, IsActive)); } public void executeQuery()// dataSource { FormRun formRun = element; if (formRun.args().menuItemName() == menuItemDisplayStr(InventSite)) { qbr.value(queryValue(NoYes::Yes)); } next executeQuery(); 

} 


Way 2:

    public void executeQuery()// dataSource { FormRun formRun = element; if (formRun.args().menuItemName() == menuItemDisplayStr(InventSite)) { this.initializeQueryFromType(); } next executeQuery(); } public void initializeQueryFromType() { QueryBuildDataSource qbDataSource; ; qbDataSource = this.query().dataSourceTable(tableNum(InventSite)); qbDataSource.clearDynalinks(); qbDataSource.addRange(fieldNum(InventSite,                                              isActive)).value(SysQuery::value(NoYes::Yes));

}

Keep Daxing!!

Wednesday, September 2, 2020

Filtering Records in a Form in AX 2012 using X++

 Hi guys,Today we see Filtering records in a Form in AX 2012 using X++.


Based on My Combo Box selection I have to filter the record in grid

On Form ClassDeclaration:

public class FormRun extends ObjectRun

{

        QueryBuildRange qr;

}


Apply the Range on Form DataSource Init():


public void init()

{

    super();

   qr=this.query().dataSourceName('InventSum').addRange(fieldNum(InventSum,Itemid));

}

On Form DataSource executeQuery():

   public void executeQuery()

{

      qr.value(Gender.valueStr());

      super();

}


IF its Enum Type Write Code on Selection change Method.

On ComboBox SelectionChange() Method Call Data Source Execute Query():

public int selectionChange()

{

    int ret;

    ret = super();

    InventSum_ds.executeQuery();

    return ret;

}


IF its String or int Type Write Code on modified Method.


public void modified()

{

    int ret;

    ret = super();

    InventSum_ds.executeQuery();

    return ret;

}


Keep Daxing!!