Showing posts with label Table. Show all posts
Showing posts with label Table. Show all posts

Tuesday, 10 February 2015

Create a Query in Axapta

Query is the most widely used AOT object in Dynamics AX customization and development. After creation it can be used as a data source in the following AOT objects: -

  • Forms
  • DataSets
  • Reports
  • Views
To create a query, follow the following steps: -

  1. In AOT select Queries node, right click and select "New Query" command. This creates a new query sub-node under the Queries node.
  2. By default "Query1" is the name of your new query. To change its name, go to properties window and change the value in the "Name" property. OR press F2 when query is selected, now you can directly write its name on the node. For example write its name as "AxdLedgerJournal".