Save enum label to a field

(0) Share

Report

Posted on by Tony zhong

901

Hi guys,

What will be the correct way of saving enum label to a field with string type ?

When I have a field, lets say MyProjInvoiceStatus (string) then in my code I want to keep the label, I found out I cannot use function Enum2Str()

I have a code that compare the status and when it meets the condition, I would directly put the enum like for example [mytable].MyProjInvoiceStatus = enum2Str(ProjInvoiceStatus::FullyInvoiced)

That one as mentioned is wrong, so what would be the correct way of doing it ?

Thanks,

I have the same question (0)

All responses (4)

Answers (1)

Martin Dráb 237,882 Most Valuable Professional on at

Like (0)

Report

Why don't you simply store the enum as en enum?

Do you want to store the actual text (such as "Invoiced" or a label ID (such as @SYS12345?

If the text, do you realize that it will stopped being translated to user's (and customers' etc.) language? Are you sure you want it? If so, which language do you want to use?

Was this reply helpful? Yes No
Tony zhong 901 on at

Like (0)

Report

Hi Martin,

Yes, to simplify the table because it is for FACT table, and would like to use English as the international language.

Thanks.

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,160 Moderator on at

Like (1)

Report

How would it be simpler than actual enum value? To me it sounds like a design decision that will just hurt you in the future.

Anyway you can use strFmt("%1", myTable.MyEnumField) to get the label in your language.

Was this reply helpful? Yes No
Tony zhong 901 on at

Like (0)

Report

Hi Nikolaos,

It would be simpler in regards of the data will be used for FACT table as it will need to de-normalized. There is no need to be in separate table like a master or lookup table for this statuses. By just exposed the description, we no need to take care what is the meaning of value 1/2/3. Also we do not need the index as we also do not need the order sequence.

However understand your concern, as and when the value needed, I will just added it as another column. Thanks for the input.

rgds,

Was this reply helpful? Yes No

Join the conversation

Community site session details

Save enum label to a field

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Save enum label to a field

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates