Now you all are aware the importance of creating views in windows client as it save the time of applying filters on the list of records. You can save the view with required filters and use it for future as it show the required data based on saved filters which improves productivity of users
Today we will see how we can create views in AL language.
Following examples illustrates how to create view from item list where inventory is greater than 10000.
In this example create new profile and added views in item list as below
Even you can apply more filters and order by also. As well as you can modify the page layout for the views as per your requirement
Publish the extension and open the business central web client .From setting change the profile and go to item List.
In the above picture you can see views has been added into the item list. Once you click on that view you can see the details as per define in views.
Following points need to remember.
- Can not use variables and methods .Can use only table fields
- Can not create new page controls from view.
- You can modify views from extension or customizations.
Hope you like this way of creating views in business central .Anyhow in upcoming versions there will option available on web client to create views as like windows client.
5 thoughts on “How to Create Views in AL Development/Business Central”
Hi, Im struggling with one issue in Business central. I want to store automatically the last list page view for each user, so next time he opens again that list window, the items are listed in the same order. I don’t know if this is possible.
I’m trying to find how views save functionality works but I can’t.
This can be possible from Client itself where in User can filter and save the view they required.
yes, I already knew that functionality. What I would like to do is to store automatically the view without the user doing anything.
I want to automate always storing the last view of a list page. I hope I’m explaining myself.
Let me check on this