We’ve had query objects for a while now – since NAV 2013 (I think). In theory they sound great, link a bunch of tables together, aggregate some columns, get distinct values, left join, right join, cross join – executed as a single SQL query.
Why Don’t We Use Queries Much?
In practice I haven’t seen them used that much. There’s probably a variety of reasons for that:
- We have limited…
Continue Reading james’s Article on their blog
Putting Queries to Use in Business Central
We’ve had query objects for a while now – since NAV 2013 (I think). In theory they sound great, link a bunch of tables together, aggregate some columns, get distinct values, left join, right join, cross join – executed as a single SQL query. Why Don’t We Use Queries Much?
Blog Syndicated with james’s Permission
More About This Author
Array
Business Central2023.05.16Tip: Out-ExcelClipboard in PowerShell
Business Central2022.11.22Trigger a Power Automate Flow from Business Central for a Selected Record
Business Central2022.11.16Getting Onboard with Power Platform as a Business Central Developer
Business Central2022.09.07Tip: Share a Git Hooks Directory Across Your Repositories
