Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[wattana thasriphet]

I create sql view on SQL Server(ax database) but view not show in ax aot (data dictionary –> view).

——————————
wattana thasriphet
TBSP,Thailand
——————————

[Tony Zeigler]

The correct process is to create the view in AX’s AOT structure, then synchronize the database.

——————————
Tony Zeigler
Strategic Solutions NW, LLC
Beaverton OR
————————————————————————-

[Jackie Olson]

If you do not create it in the AOT, the next time you run an AOT synch, it will delete the object from SQL.

——————————
Jackie Olson
Stoneridge Software Inc.
Barnesville MN
————————————————————————-

[Scott Morley]

Wattana,

For items to appear in the AOT you have to create them from the AOT. The view you created in SQL cannot be made visible in the AOT, you need to create a view in the AOT and it will push it to SQL. If you don’t want to do that, you can access the view from AX through an ODBC call in a class. It wont add it to the AOT but you will be able to use it. The ODBC call is supported but not best practice.

If you are new to views in AX you can find information about them and how to create them at View Basics [AX 2012]

Microsoft		remove preview
View Basics [AX 2012] In Microsoft Dynamics AX, you can use views where you use tables. For example, you can use a view in a form, a report, and in X++ code. The following table shows the benefits of using a view instead of a table. View this on Microsoft >

——————————
Scott Morley
Principal Application Architect
OneNeck IT Solutions
Bend OR
————————————————————————-