Retrieve Enum Caption In Query

(0) Share

Report

Posted on by RyanMCHS

Hi,

I currently have an enum for storing a list of a data that a user can select, that looks like this:
Enum code

I made a table extension for the Job table and a page extension for Job Card, where the user can select from this list. All of that works fine, but once I try to query the table, I just get the integer value for each of the choices. Is there a way that I can store the caption, rather than the integer in the table? If not, would it be possible to convert the integer value to the caption within my query?

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

YUN ZHU 95,311 Super User 2025 Season 2 on at

Like (0)

Report

Hi, Kauffmann has discussed this in detail before.

https://www.kauffmann.nl/2020/07/16/converting-enum-values-in-al/

Hope this helps.

Thanks

ZHU

Was this reply helpful? Yes No