O'Reilly logo

Learning MS Dynamics AX 2012 Programming by Erlend Dalen, Mohammed Rasheed

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 5. Searching for Data

In this chapter, you will learn about different mechanisms for retrieving data from the database:

  • Queries that are reusable and are often used in reports and periodic jobs
  • Views that are created in AOT and translated to optimized select statements at runtime
  • The select statements that are used in X++ to fetch data from the database to the application

After reading this chapter, you will know how to use these mechanisms and which one of them to use in different cases.

Queries

Queries are typically used to ask users about ranges and sorting and selecting data based on the feedback from the users. A query can consist of one or multiple data sources and can be created both as static queries in AOT or as dynamic queries using ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required