SetLoadFields – Pardaan.com

Who benefits from partial records: The true magic of SetLoadFields

One of the key characteristics of the C/AL language and its more modern ancestor, AL, that makes it so attractive for developers, is simplicity that makes the journey into the application development world much more comfortable even for people coming from a different background. Source :…

11 July 2023

Dynamics NAV & BC Tips & tricks

Using partial records in Business Central (SetLoadFields)

Business Central allows us to set or select the fields that will be initially loaded when the record is retrieved from its data source, improving the performance of objects such as OData pages and reports, and particularly beneficial when using table extensions in the application. Source…

16 September 2022

Dynamics NAV & BC Tips & tricks

Relationship between BLOB fields and SetLoadFields()

It was great to hear a lot of positive comments after I published my previous post so I hope I won’t disappoint you and that this post will be at least as useful as the previous one. At the moment, we are experiencing some performance issues…

22 December 2021

Dynamics NAV & BC Tips & tricks

Dynamics 365 Business Central: SetLoadFields performances with reference passing or value passing parameters

The partial records capability is one of the latest and more important feature available in Dynamics 365 Business Central for writing performant code. Using Record.SetLoadFields can help you on improving your performances, expecially when looping through records. In this way you can avoid joins with table…

10 June 2021