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

Wednesday, April 20, 2022

Add default filter in Systemdefinedfiterpane in D365FO

 Today we see to add default filter in Systemdefinedfiterpane.




For this we need to use QueryFilter class. Write the below method in form init method. I am using vend group table.


[ExtensionOf(formStr(VendGroup))] public final class TestVendGroupForm_Extension { public void init() { next init(); // QueryFilter qFilter; QueryBuildDataSource qbd = VendGroup_ds.queryBuildDataSource(); // qFilter = VendGroup_ds.query().addQueryFilter(qbd, fieldStr(VendGroup, PaymTermId)) VendGroup_ds.query().addQueryFilter(qbd, fieldStr(VendGroup, PaymTermId)); //VendGroup_ds.query().addQueryFilter(qbd, fieldStr(VendGroup, Name));         

        // ------Or---------------         this.addFilterPaneRanges(); }     /// <summary> /// Adds ranges to filter pane. /// </summary> protected void addFilterPaneRanges() { QueryBuildDataSource inventSumQbds = InventSum_DS.query().dataSourceName(InventSum_DS.name()); SysQuery::findOrCreateRange(inventSumQbds, fieldNum(InventSum, ItemId)); QueryBuildDataSource inventTableQbds = InventTable_DS_DS.query().dataSourceName(InventTable_DS_DS.name()); SysQuery::findOrCreateRange(inventTableQbds, fieldNum(InventTable, NameAlias));

    } }


Keep Daxing!!

Tuesday, April 6, 2021

How to call child form with filtered records using X++ in D365FO

 How to call Form with filtered records using X++ in D365FO.


check below code.

    =======================Using Form Run======================

    {

        Args            args = new Args();//(formStr(formName));

        FormRun         formRun;

        FormDataSource  formDataSource = new FormDataSource();

        ;

        args.name(formStr(formName));

        formRun = ClassFactory.formRunClass(args);

        formRun.init();

        formDataSource = formRun.dataSource();

        formRun.run();

        formDataSource.filter(fieldNum(TableName, FieldName), "Value");

        formRun.detach();

        -------------------------------------------------OR-----------------------------------------------

        Args args = new Args();

        args.caller(_caller);

        args.parm(_parm);


        FormRun fr = new MenuFunction(menuitemDisplayStr(FormName), MenuItemType::Display).create(args);

        fr.run();

        fr.dataSource().findRecord("Value");

        fr.detach();

    }


====================Using Menu Function===========================


    {

        MenuFunction            menuFunction;

        FormRun                 formRun;

        Args                    args = new Args();

        ;


        // args.record(TableBuffer);

        args.lookupRecord(TableBuffer); //Below 2 methods are also working same

        // args.lookupField(fieldNum(TableName, FieldName));

        //args.lookupValue('Value');

        menuFunction = new MenuFunction(menuitemDisplayStr(EcoResAttributeType), MenuItemType::Display);

        menuFunction.run(args);

    }


Keep Daxing!!