Base enums literals

(0) Share

Report

Posted on by Ammar Salah

150

Hi All, Can somebody please provide an article or explain to us the Literals property on Base Enums (D365 FinOps) and also the reason why we have table in SQL named ENUMVALUETABLE and how does it work.

I have the same question (0)

All responses (5)

Answers (0)

MATTGUO 22,349 Moderator on at

Like (1)

Report

Hi Ammar,

Enums in X++ are defined in AOT to represent a list of literals, or named constants, enum literal is the value of enum(such as “table” in the picture).

Enum values are represented internally as integers.

The ENUMIDTABLE table stores the base enum ids while the ENUMVALUETABLE table stores the numeric values assigned to every element of the base enum. While the ENUMIDTABLE table contains records for every base enum in the system, ENUMVALUETABLE is only populated for extensible enums.

Refer to:https://www.axug.com/blogs/cruz-margaix-huerta/2019/02/20/moving-an-overlayered-enum-to-an-extension-in-a-sa

Moved this post to D365 Finance forum: https://community.dynamics.com/365/financeandoperations/f/dynamics-365-for-finance-and-operations-forum

Was this reply helpful? Yes No
Ammar Salah 150 on at

Like (0)

Report

Thanks for sharing the article, any idea regarding the Literals property on base enum? Also when we rename one of the values in base enums or add/delete enums the ENUMVALUETABLE does not sync correctly it doesnt remove any deleted base enum (after DB sync).

Was this reply helpful? Yes No
MATTGUO 22,349 Moderator on at

Like (0)

Report

Hi Ammar,

How did you change your base enum, did you extend it correctly?

Have a look at the keywords forcePlaceholders and forceLiterals of the Literals property, and you don’t have to change it.

https://docs.microsoft.com/en-us/dynamicsax-2012/developer/select-statement-syntax?redirectedfrom=MSDN

Was this reply helpful? Yes No
Ammar Salah 150 on at

Like (0)

Report

Thanks MATTGUO, any way my base enum is customized. changing the Extensible to false i can see the EnumValue now

----

Was this reply helpful? Yes No
MATTGUO 22,349 Moderator on at

Like (0)

Report

Hi Ammar,

If the enum is not extensible, the Enum Values are stored as metadata in the enum XML file.

And extensible enums have their values stored in SQL.

Was this reply helpful? Yes No