O'Reilly logo

Microsoft Dynamics AX 2009 Programming: Getting Started by Erlend Dalen

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 the different methods of retrieving data from the database. They are as follows:

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

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

Queries

Queries are typically used to ask users about ranges and sorting, and then 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 the AOT or ...

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