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
