Dynamics AX 2012 SQL Extraction of Base Enum Values

Question

Is there a table, view, or procedure I can use to extract the values from a Base Enum using SQL (straight from the DB, not within X++)? I was able to find an isolated few in the table SRSAnalysisEnums but not the enum I need in particular.

Answer 1

If you are trying to access the Enums from outside AX (for example in sql) you can add the missing enums to SRSAnalysisEnums by adding the containing table to a perspective and rebuilding the models

Tools->Reporting tools->Update models

It is described here http://abraaxapta.blogspot.co.uk/2012/02/missing-enums-in-srsanalysisenums.html

And an different AX2012-only way of doing it

http://abraaxapta.blogspot.co.uk/2012/11/accessing-enum-labels-from-outside-ax.html

Hope this helps