Thursday 13 December 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:

  1. These are some great tools that i definitely use for SEO work. This is a great list to use in the future..
    on the site pozyczki-24.pl

    ReplyDelete

Adding a newline into a string in C# and X++

Below is the sample code we can use for  adding a newline after every occurrence of "@" symbol in the string in C#   using System...