Thursday, December 13, 2018

Sorting data in a form datasource in Dynamics Ax 2012 / D365F&O X++

In Microsoft Dynamics AX, you can sort a form datasource when the form is loaded.

On the form, override the init method.

After the call to super(), add the sort field to the form datasource.

public void init()
{
    super();

    salesLine_ds.query().dataSourceTable(tableNum(SalesLine)).addSortField(fieldNum(SalesLine,         ConfirmedDLV), SortOrder::Ascending);
}

If you need to sort on multiple fields, keep adding the fields you need with the addSortField method.

public void init()
{
    super();
   
    salesLine_ds.query().dataSourceTable(tableNum(SalesLine)).addSortField(fieldNum(SalesLine,        ConfirmedDLV), SortOrder::Ascending);

    salesLine_ds.query().dataSourceTable(tableNum(SalesLine)).addSortField(fieldNum(SalesLine,        SalesStatus), SortOrder::Ascending);
}

1 comment:

Why do users often get confused about Dynamics 365 Customer Engagement (D365 CE), Dataverse, and the Power Platform?

  The Microsoft ecosystem for business applications can sometimes be difficult to navigate, especially when discussing Dynamics 365 Customer...