Sunday, 20 February 2022

Filter DataSource in form D365 FO

[Form]

public class DDD_ViewContracts extends FormRun

{

    [DataSource]

    class DDD_ViewContractsView

    {

        public void init()

        {

            if(element.args().record())

            {

                SalesTable   salesTable = element.args().record();

                super();

                Query q = DDD_ViewContractsView_ds.query();

                QueryBuildDataSource rootDS = q.dataSourceTable(tablenum(DDD_ViewContractsView));

                rootDS.clearRanges();

                QueryBuildRange range = rootDS.addRange(fieldnum(DDD_ViewContractsView, CustAccount));

                range.value(SysQuery::value(salesTable.CustAccount));

                range.status(RangeStatus::Locked);

                if(salesTable.InventLocationId)

                {

                    range = rootDS.addRange(fieldnum(DDD_ViewContractsView, LocationId));

                    range.value(SysQuery::value(salesTable.InventLocationId));

                    range.status(RangeStatus::Locked);

                }          

            }

        }

    }

No comments:

Post a Comment

Financial reporting DataMart reset in D365 FO X++

  https://community.dynamics.com/blogs/post/?postid=f866f228-4ca5-4013-b996-ec2fe9dde72e