Hey!
In D365FO some BaseEnums doesn’t have the Enum Value property in its elements.
This happens because the ABC BaseEnum is extensible.
To comply with the extension framework Microsoft introduced a new property on BaseEnums that determine if the enum is extensible or not. If the Enum is extensible then its elements will be automatically numbered.
If the enum is not extensible the Enum Values are stored as metadata in the enum XML file.
On the other hand, extensible enums have their values stored in SQL.
Here is a SQL script to help find out extensible enums Enum Values:
SELECT * FROM ENUMVALUETABLE
JOIN ENUMIDTABLE ON ENUMVALUETABLE.ENUMID = ENUMIDTABLE.ID
WHERE ENUMIDTABLE.NAME = 'BaseEnumName'
3 Comments
Tri Than · October 1, 2021 at 3:51 am
I create one enum with 2 elements. After that I set “is Extensible” property of my enum is ‘true’, and I check the value of elements, its result is 1 and 2.
Why the value of the first element is 1 but not 0.
Can you help me?
ptornich@hotmail.com · November 21, 2022 at 9:06 am
Extisible enum values are meant to be agnostic. In other words, you should not know or care about those values, since you cannot change them.
euripides · September 12, 2023 at 10:32 pm
Gooɗ post however I was wondering if you could write a litte more on this subject?
I’d ƅe very ɡrateful if you could elaborate a little bit more.
Bless you!