Finance | Project Operations, Human Resources, ...

How to determine the AOT Model for a given Table in code using D365F&O

(0) Share

Report

Posted on by Sophia.r

235

I have a requirement where I need to have a List of all the tables in the AOT, but I would like to add the specific AOT Table's Model as well.

I retrieved the table list by using the SysTableIdView, and then determined the Table Properties using SYSDictable. How can I determine what the name of the model is for the given table.

All internet comments indicate that I should use SysModelElements, but that is empty in 365F&O.

Would appreciate if someone can help.

I have the same question (0)

All responses (4)

Answers (0)

André Arnaud de Cal... 300,904 Super User 2025 Season 2 on at

Like (0)

Report

Hi Sophia,

For what reason do you need this? The information is available in Visual Studio. Can you explain what you want to achieve?

Was this reply helpful? Yes No
WillWU 22,361 on at

Like (0)

Report

Hi Sophia,

SysModelElements is a system table and it was used in AX2012, you will not find any data in D365FO.

You can use Microsoft.Dynamics.AX.Metadata.Storage.MetadataProvider.

See:

gist.github.com/.../4d4d06ec2fddd885b67527623467aee8

Hope this helps.

Was this reply helpful? Yes No
Martin Dráb 237,795 Most Valuable Professional on at

Like (0)

Report

You can use the metadata API, or you could do it at file level (by iterating model folders and list files under AxTable subfolder).

Was this reply helpful? Yes No
Suggested answer

Fangyuan Hou on at

Like (0)

Report

Hi Sophia,

You can use the MetaModelService(Microsoft.Dynamics.AX.Metadata.Service) to get the modelinfo with a table name.

There are two public method under MetaModelService.

public ModelInfoCollection GetTableModelInfo(string tableName)

public ModelInfoCollection GetTableExtensionModelInfo(string tableNameExt)

Below is the sample code for your reference:

using Microsoft.Dynamics.AX.Metadata.Service;

using Microsoft.Dynamics.Ax.Xpp.AxShared;

using Microsoft.Dynamics.AX.Metadata.MetaModel;

Was this reply helpful? Yes No