How to sort data on grid of form in AX 2012

In Microsoft Dynamics AX 2012 and Microsoft Dynamics 365 for Finance and Operations, grids are used very often on the form. If you want to sort data on grid of form in AX 2012 by ascending or descending orders. You are at the right place to learn.

The requirement is that I want to sort data on grid of form in AX 2012 when the form is opened. After successfully fulfilling the requirement in Microsoft Dynamics AX 2012, I planned to share my experience.

So, if you want to sort data on grid of form in Microsoft Dynamics AX 2012, you need to write two lines in the data source’s init() method after super() is called. Before starting, you should know the following:

In my case, I have used the following:

To implement the solution to sort data on grid of form in AX 2012, follow these steps:

• Open the development work space
• Go to AOT -> Forms -> FORM -> DATA SOURCE -> Methods
• Override the init() method of data source if it does not exist, or, open the existing init() method
• After super(), add the following code:

//Moeen Ahmed Sultan
//It will clear if any other sorting is applied on the grid
this.queryBuildDataSource().sortClear();

//It will add the sorting on the field
//Use the table and field as per your own requirement in fieldNum function.
//Use the ascending or descending order as per your own requirement
this.queryBuildDataSource().addSortField(fieldNum(SysDataBaseLog,CreatedDateTime),SortOrder::Descending);

Using the above two lines, you will be able to get the sorted data when the form is opened. In this way, you will achieve your requirement that is sort data on grid of form in AX 2012.

Blog: Click here

YouTube: Click here

GitHub: Click here

If you found any ambiguity or better solution, please let me know. If this helps you, please like, comment and share.

Dreams don’t work, unless you do.

Moeen Ahmed Sultan

I am Moeen Ahmed Sultan from Pakistan, an Independent technical consultant for Microsoft business applications. I am Microsoft Certified Professional, I always seek opportunities to showcase my skills in the extensive field of Computer Science. I have successfully championed to the enterprise by working in extensive areas including Microsoft Power Apps, Microsoft Dynamics AX 2012, Microsoft Dynamics 365 for Finance & Operations, and Microsoft Share Point Online thereby fueling the industry-wide transition.