Today I would like to share another mini tip about Business Central, how to check if a record/table is temporary in AL.
A temporary table is a temporary variable that holds a table. A temporary table is used as a buffer or intermediate storage for table data.
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:
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:
I’m currently working on a new app (for AppSource) and I need fast accessible information throughout a user session that I can look up without having a performance impact on the user experience.
What do you think about temporary records and transaction scopes?
Most of developers think temporary records are managed as transactions, but it’s not.
Maybe some of you remember my how-to increase performance by reducing db reads.
I wrote it in 2007 when we still had the native DB and also the SQL DB but NOT the service tier with all its extra’s for performance.
Very often when developing we have logic we would like to execute on records, but only when the table is actually a real table and not when used as a temporary record. This could be things like inserting, modifying or deleting attached records in another table which would make no sense in most cases if the table you are currently in is temporary.