High Performance Data Access: Why and How to Use Queries in Microsoft Dynamics NAV 2015

Editor's Note: This article is adapted from the new book Programming Microsoft Dynamics NAV 2015 by David Studebaker and Christopher Studebaker, published by PACKT.

The Query object in Microsoft Dynamics NAV 2015 originated in NAV 2013 with improved performance in mind. It allows us to create advanced T-SQL queries using familiar NAV tools.

Externally, a Query can be used as:


Requires FREE Membership to View

Become a Member Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more, and it’s all FREE. You’ll also receive periodic email newsletters with the latest relevant articles and content updates.
About Christopher Studebaker

Chris Studebaker has been designing, developing, implementing and selling in NAV and SQL Server since 1999, specializing in high user count, high data volume applications in retail, manufacturing, job shop, and distribution. Chris has worked on many NAV implementations with integrations to external databases and third party add-on products.  Some special applications have included high volume order entry, pick-to-light systems, procurement analysis and Web front ends.  Chris is a Senior Consultant for UXC Eclipse. 

Read full bio...

About David Studebaker

David Studebaker is Chief Technical Officer and co-founder of Liberty Grove Software. David has had a wide range of development, consulting, sales and management roles throughout his career. He has been partner or owner and manager of several software development businesses, while always maintaining a significant role as a business applications consultant, developer and author. David started programming in 1962, co-developed the first production SPOOL software in 1967 for the IBM System/360, and has been developing in NAV C/AL since 1996.  

Read full bio...