Microsoft Dynamics AX (Archived)

List of All Table with ID, Name and Label

(0) Share

Report

Posted on by Community Member

Can anyone help me to retrieve the list of all tables in ax 2009 with ID, Name and Label

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report
yeah you can get list as following

static void ListOfTables(Args _args) { UtilElements localEelmet; UtilEntryLevel LayerName = UtilEntryLevel::usr; TreeNode treeNode; ; while select localEelmet where localEelmet.utilLevel == LayerName && localEelmet.recordType == UtilElementType::Table { treeNode = xUtilElements::getNodeInTree(xUtilElements::parentElement(localEelmet)); info(strFmt("TableId: %1 ; Name: %2",localEelmet.TableId,localEelmet.name)); } }

But remember, running job can take long time, so better to use progress bar and save this information somewhere in new table or on any report.

Also don't forget to change/remove Layer range in query, as per your own need

Was this reply helpful? Yes No
Suggested answer

Rudi Hansen 4,075 on at

Like (1)

Report
This job should do the trick.

static void TableList(Args _args) { tableId tableId; int tablecounter; Dictionary dict = new Dictionary(); for (tablecounter=1; tablecounter<=dict.tableCnt(); tablecounter++) { tableId = dict.tableCnt2Id(tablecounter); info(strFmt("TableId: %1 ; Name: %2 ; Lable: %3",tableId,tableid2name(tableId),tableid2pname(tableId))); } }

Was this reply helpful? Yes No
karthickarden 135 on at

Like (0)

Report

Hi,

I want to get the custom tables list from Dynamics AX 2009 through C#.

Could you please provide the sample code

Thanks

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

Like (0)

Report

You already have X++ code doing that.

Use Business Connector to call X++ code AX 2009 from C#.

Was this reply helpful? Yes No