Book Image

Extending Microsoft Dynamics AX 2012 Cookbook

By : Murray Fife
Book Image

Extending Microsoft Dynamics AX 2012 Cookbook

By: Murray Fife

Overview of this book

Dynamics AX is built on a number of foundation products from Microsoft that are used to make it bigger, better, and stronger than the average business system. Taking advantage of these products will make your life easier. Use these tools to maximize the efficiency of your business management, taking advantage of a powerful and centralized tool set. "Extending Microsoft Dynamics AX 2012 Cookbook" will show you how to use tools that you already have to extend out Dynamics AX and discover potential new directions. You will be surprised at what you can do on a shoestring budget. The book will allow you to streamline your work processes, and use the system's powerful and centralised features to the advantage of your organization. "Extending Microsoft Dynamics AX 2012 Cookbook" will show you how to maximize the potential of Dynamics AX with common and popular tools to enhance your business management systems. We will begin by exploring how to extend Dynamics AX out with SharePoint. After this, the book will guide you through important elements in maximizing business management efficiency, focusing on key aspects like reports, dashboards, and workflows. The book will then finish by teaching you how to customize your management systems, achieving a comprehensive coverage of the most important extension processes relevant to you and your business with very little programming. This is a book for those of you that want to make the most out of Dynamics AX by using what you already have, and without breaking the bank.
Table of Contents (18 chapters)
Extending Microsoft Dynamics AX 2012 Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Creating custom OData queries to retrieve Dynamics AX data


Dynamics AX has a more generic web service call feature called OData Query that allows you to query tables and return them through a URL. This is useful because they can be used as read-only data sources for other programs such as InfoPath.

In this recipe, we will show how you can register your own custom query within Dynamics AX, and then access it through the OData Query web service.

How to do it...

To create an OData query, follow these steps:

  1. To access a query through the OData Query feature, we open the Document data sources form from the Organization Administration area page within the Document Management folder of the Setup group.

  2. To create a new query, click on the New button in the menu bar.

  3. The Document data sources reference the queries that are built within AOT. Usually, you don't have to build a whole new query because you can use one of the existing ones as a basis. Select a module that you would like the data source to be...