Get All Enum Item Name description

(0) Share

Report

Posted on by Mhaider

Hi All,

I would like to get all the descriptions against enum values. I was looking this table( select * FROM SRSANALYSISENUMS ) it does not have all the descriptions. e.g. JopPayType in Project Data entity, ProjectStatus. In these columns number values are coming like 0,1, 2 etc.

Is there anyway to extract all descriptions against enum values in excel or csv or direct to SQL Server table?

Look forward to hearing a suggestion or answer soon.

Many thanks.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

add on at

Like (0)

Report

Hello Mhaider,

Try this one:

https://msdn.microsoft.com/en-us/library/dictenum.index2label.aspx

Was this reply helpful? Yes No
Mhaider on at

Like (0)

Report

Thank you for your reply add. How can I see the output? Can I have an output direct to SQL Table or in a CSV file?

Regards.

Was this reply helpful? Yes No
add on at

Like (0)

Report

Hello Mhaider,

The link I sent you is a X++ code. You can test and see its output in a Job (Runnable class) but I am not sure if it is applicable for your version. As for SQL/CSV output I am sorry but I can't help you.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

Like (0)

Report

Hi Mhaider,

The SrsAnalysisEnums table is having the enumerations which are part of perspectives (AOT > Data Dictonary) only. You can add tables into (new) perspectives or write own logic to populate data in a table or file.

Was this reply helpful? Yes No
Mhaider on at

Like (0)

Report

Hi Andre, Thank you for your reply. Does it mean that there is no way to get all enum values except to write code in X++ and populate SQL table?

Was this reply helpful? Yes No
André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

Like (0)

Report

The other option is to add the tables using other enumerations in perspectives.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

This was possible some years back directly from SQL. Now due to changes on the data model and properties of AX objects, the SQL script requires tweaking as the owner of the solution has mentioned. I am going to link it here, maybe you have the time and resources to get it updated, and share the final solution with us:

community.dynamics.com/.../156472

Was this reply helpful? Yes No
Mhaider on at

Like (0)

Report

Hi Vilmos, I have seen this already. But I am new to AX /D365 will see if i can find something.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

If there is no updated version for that script and you cannot fix it yourself, that means it is not possible to directly fetch all enumeration labels from the database without some form of customization. You would need some sort of metadata provider class for that, which means writing X++ code, or doing the Perspective tables to get it populated for reporting purposes, as it was suggested above.

Was this reply helpful? Yes No
Mhaider on at

Like (0)

Report

Hi, I found this msdn.microsoft.com/.../ledgerpostingtype.aspx where all enumerations are available. Question here is how frequently it gets updated? You can see all enumeration's descriptions. can we use this as a source if we know it does not update frequently?

Was this reply helpful? Yes No