Dynamics 365 Business Central: AL Query objects and the new ReadState property.
AL query objects in Dynamics 365 Business Central are designed for efficient data reading by defining a result set using tables, columns, and filters. They support operations like aggregation and row limitations, and can be converted into OData endpoints by setting their type to "API". The transaction isolation level, now adjustable starting from the 2026 Wave 2 release, determines the precision and locking behavior during query executions. There are four levels—ReadUncommitted, ReadCommitted, ReadShared, and ReadExclusive—each offering varying degrees of data access and row stability, affecting how queries read and interact with other database operations. Choosing the right level depends on the intended use of the query results, balancing safety and performance. For instance, permissive settings like ReadUncommitted are adequate for data display, while stricter levels are preferable when results guide consequential database operations. Careful consideration of the ReadState property can enhance application reliability and responsiveness.
Article 3w
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time