How to Create Views in AL Development/Business Central

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.

  1. Can not use variables and methods .Can use only table fields
  2. Can not create new page controls from view.
  3. 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.

Cheers….

Author: Ammolh Saallvi

I'm a Dynamics NAV/Navision developer and helps partners and end-users with their NAV implementations. I do everything from third-party management advisory, training to new NAV teams, project management, training, setup and development. Do you want to hire me to help getting your project a success? Then contact me via dropping one email from linkedin Expertise in end-to-end development of software products from requirement analysis to System Study, Documentation and Testing. Demonstrated abilities in analyzing information system needs, evaluating end-user requirements, custom designing solutions, troubleshooting for complex information systems management. Deft at carrying out risk analysis, impact analysis, project reviews and documentation. Strong Problem solving & Technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction as well as low operational costs. Certifications:- Microsoft Certified Technology Specialist -Dynamics Microsoft Sure Step Certified Professional Moderator at DUG Forum Specialties: • ERP Implementation • Client/Server Programming • Coding, Testing, troubleshooting and documentation. • Database Tuning and SQL • Database Performance • Debugging large programs • Project Management and Resource Management.

5 thoughts on “How to Create Views in AL Development/Business Central”

  1. 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.

    Like

      1. Hi Ammolh!
        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.

        Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.