Search code examples
sqlaxaptadynamics-ax-2012

Dynamics AX 2012 SQL Extraction of Base Enum Values

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.

Solution

  • 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