Finance | Project Operations, Human Resources, ...

Need Values for ENUM Codes in Microsoft Dynamics AX

(1) Share

Report

Posted on by Akash Kannan

Hi Team

I use MS Dynamics AX 2012 R3 Trial instance , in backend the Values are got as ENUM codes but i need the equivalent values for that Enum codes. Is AOT is the only way to reterive ENUM Values or what are the ways available to reterive it. in my AX instance there is no developer license configured . so, i unable to access AOT here. Please suggest me solution to retrive ENUM Values

Categories:

Microsoft Dynamics AX

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Shaluma 355 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Akash Kannan,

You can query these two system tables directly in SQL Server join ENUMIDTABLE and ENUMVALUETABLE on the enum ID to get the enum name and its values, please check the Sql in below query and refer the below URL,
https://d365ffo.com/2021/12/18/ax-d365fo-how-to-get-a-base-enum-integer-internal-value-with-a-sql-server-query-or-a-job/

select * from ENUMIDTABLE
join ENUMVALUETABLE
on ENUMVALUETABLE.EnumId = ENUMIDTABLE.ID
where ENUMIDTABLE.NAME = 'Enum Name' // Replace with your enum name

To find all available enums :
select distinct Name from ENUMVALUETABLE order by Name

If that above table which I have mentioned is empty in your trial instance, please check the given URL,
https://www.tech.alirazazaidi.com/enum-values-missing-in-srsanalysisenums-table/

This works directly on the AX business database and does not require developer license or AOT.

Thanks,
Shaluma

Was this reply helpful? Yes No
Akash Kannan 34 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @shaluma

The above mentioned tables were not available in my database. In the second URL, they mentioned SRSANALYSISENUMS , in that table there is no data. what to do next, is any other method.

Was this reply helpful? Yes No