Today I would like to share another mini tip about Business Central, how to get the sort order for the records returned in AL.
Tag Archives: Sort
How to sort data with AL
Sorting is a classic computer science challenge, and sometimes in AL you also need to sort. In this video, I take a look at that challenge from an AL perspective. Check it out:
Using Search, Sort, And Filter Features In Microsoft Dynamics Business Central To Get The Data You Need Faster
Microsoft Dynamics 365 Business Central has the tools you need to find and report on the data in your ERP system. Understanding how to search, sort, and filter is critical.
Watch this video to see how to search and sort your data in list views and how to use the powerful filter options in both list views and reports to get the data you need to make informed decisions. You’ll also find tips for search criteria as well as how to access hidden data fields for filtering.
How-to: Sort Columns – SETASCENDING
Since NAV 2013 we are more and more getting the full potential out SQL Server.
In NAV 2009 (and before) it was, for example, unimaginable to setup “your own” sorting for your data retrieval as SETCURRENTKEY only allowed you to use the keys defined on the table you were going to query. Or not possible for users to sort their lists by any column, like they had been used to in, for example, Excel long time.
Tip #48 | Filtering and Sorting in Journals
Did you know that in each Journal in Microsoft Dynamics NAV you can sort on a column, filter and then post only these lines in that particular order?
How to set dynamically the Key and Sort Order for the pages using NAV 2009 Web Services feature
The default methods exposed when a page is published are the so-called CRUD (Create, Read, Multiple and Delete) methods. All of those does not allow to set up previously a key for sorting order nor if the records have to be ascending or descending.