Whenever you need to get a value1|value2|value4..value10|… field filter from a provided record variable, then the GetSelectionFilter method from the SelectionFilterManagement codeunit is your friend. However, using this function has one drawback, as you can read in the Remarks section:
Tag Archives: Record
When partial records and indexes reach synergy
Continuing performance testing of queries on extended Business Central tables, today I want to look at the same dataset from a slightly different angle. If you read my previous post, you may remember the conclusion from the first test run: partial records are not a silver bullet to solve all performance problems in the application, but applying SetLoadFields on record variables can definitely help to protect the application from performance degradation in case when the application table is extended.
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.
Lookup any Record, from any Table
Have you ever wondered if you could create more flexible lookups? Maybe you have a function where the user is required to select a record from a specific table, depending on the situation?
Analyze (the lack of) Partial Records with Business Central Telemetry
I’ve been working with Business Central Telemetry a lot the last coulple of months, having to deal with deadlocks and such. And while doing so, quite some new ideas came to mind that I’d like to investigate by means of Telemetry.
The Copy method on temporary records
If you ever needed to copy temporary record variables, you probably already stumbled across ToRecord.Copy(FromRecord, true), with the second parameter true being used. But be careful: it works differently than you might think!
Imagine two temporary record variables, both pointing to the same base table:
Creating Power BI Reports for Displaying List Data in Dynamics 365 Business Central (Filter the Power BI report based on the selected record)
Dynamics 365 Business Central includes a Power BI FactBox control element on many key list pages. The purpose of this FactBox is to display Power BI reports that are related to records in the lists, providing extra insight into the data. The idea is that as you move between rows in the list, the report updates for the selected entry.