How to store Enum label instead of Enum value in D365 finance and operation

(0) Share

Report

Posted on by Community Member

I want to store enum label rather than enum value in my DB side. for example i have one base enum "Status" value of this enum is (0 for Open , 1 for Closed ). in DB i want to store open and closed instead of 0 or 1. i found one code for the same. if this is the correct way to implement , in which method i should write this code. Please advice if there is any other way to achieve it

SysDictEnum dictEnum = new SysDictEnum( enumnum(InventTransType) );

dictEnum.value2Label(InventTrans.TransType);

I have the same question (0)

All responses (6)

Answers (1)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

moved to the d365 forum

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

Hi Sachin,

AX stores enums as integers in DB.

So I think you cannot store label for that.

Why are you need to store label?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello Blue , Actually i am using this table in one MS Flow (Power Automate), that flow send records of this table through email and record value appears in Email body for now it is appearing as enum value as 0,1,2.. not the label.

Other way is i have to use cases in SQL script to assigning label to the values but i am avoiding that. i want to store value as label in the DB itself if possible.

Please check this link (Link)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Sachin,

You can directly use Enum2Str().

Neither I don't think it's a good way to directly store the label in db.

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

Enums are always stored as integers as others have pointed out. Each enum value maps to exactly one integer number but it can map to 50 labels (which might also change).

How it's stored is one thing, and how you present it in your Power Automate is another. But you should focus your efforts in showing it in the format that you need.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello Nikolaos, Thanks for the detailed advice. i am now working on displaying enum as per my requirement rather than changing it on DB Side

Was this reply helpful? Yes No