Save enum label to a field

(0) Share

Report

Posted on by Tony zhong

903

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)

Sort by

Martin Dráb 239,360 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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 903 on at

Like (0)

Report
Copy link

Link copied!

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,172 Moderator on at

Like (1)

Report
Copy link

Link copied!

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 903 on at

Like (0)

Report
Copy link

Link copied!

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