Skip to main content

SetLoadFields in Business Central

How to Use SetLoadFields in Business Central?

SetLoadFields is a wonderful characteristic of business central wave 2 2020. Conventionally, we are used to load all fields data together whenever we fetch records from table. At that moment, I think it fires a Select * From Table query in the background. So, it will take little bit more timing in retrieving the data. We can reduce this time with the help of SetLoadFields when we use this function. I suppose it will use Select Field From Table query to fetch the data. This will impact a lot as far as performance is concerned. Also, we can use SetLoadFields with Setrange and Setfilter to get our desire records. Here, I have used Setfilter along with SetLoadFields.

pageextension 50100 CustomerListExt extends "Customer List"
    trigger OnOpenPage();
        Item: Record Item;
        total: Decimal;
        Item.SetFilter("No.", '%1|%2''1953-W''1960-S');
        Item.SetLoadFields(Item."Unit Cost");
        if Item.FindSet() then
                total += item."Unit Cost";
            until Item.Next() 0;
        Message('%1', total);


There are other functions that can be used for Partial records capabilities but I guess SetLoadFields is the most important for developer like us.


  1. Try running your code with/without the use of SetLoadFields. Then you can see the SQL statements in the database statistics part of the debugger


Post a Comment

Popular posts from this blog

Import Excel File in Business Central

Import Excel in Business Central Many times we need to import data through excel file in the business central / navision. We used to perform this kind of activity in the navision but we need to explore the thing in business central. So, i am trying to import data from excel file in the business central. I am using business central wave 1 2020 for the development. We will create a table called student and add some fields to test imported data from Excel in Business Central. Now, We will add a new list page to view imported data from excel. Now, We will create a new report to import data from the excel in business central. If you worked with the navision then you might be noticed that some of the functions are not working in the business central due to scope issue. So, we will replace those functions which we used in NAV and try some new available functions to import excel. Now, we will add an action to the list page for import data.

Custom API in Business Central

Today, I will demonstrate how to work with custom API in Business Central. Custom API is very useful when we are working with integration apps. So, lets start exploring custom API in business central. We will take one table called student and will create one API page in order to access this table as API. Moreover, we can check this API in Postman as well. Here, we will mainly perform three operations GET, Post, and Delete. First of all, we will create student Table with four fields ID, First Name, Last Name and Email. For the primary key we will take ID. Once table is added, we will create one list page to view our data. So, we can easily check our custom API is working properly or not. Now, we will add another page which is used as API. This is a new page type introduced in business central. You can check how to create API page in business central.( Click Here ) Now, we can interact with student  data with the help of this API page in the business central. We will write a logic in cod

Enable Code Analysis for AL In BC

How to use Code Analysis Tool for AL in BC Few days ago, the demo was given by me on the code analysis for AL among our team. I would like to share the same knowledge with you on the code analysis. Follow the bellow steps in your project to enable code analysis in the business central. Open command pallete ( Ctrl + Shift + P ) and choose either User Setting or Workspace settings.  Basic setting is al.enablecodeanalysis and make it to true. Now, set the al.codeanalyzer with the different values. Here, there are four values (AppSourceCop, CodeCop, PerTenantExtensionCop, UICop) available to use. Here, we will user CodeCop and PerTenantExtensionCop.  CodeCop is an analyzer that enforce the official AL coding guidelines. AppSourceCop is an analyzer that enforce rules that must be respected by extensions meant to be published to Microsoft App Source. PerTenantExtensionCop is an analyzer that enforce rules that must be respected by extensions meant to be installed