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?

Categories:

Reports and Business Intelligence

Other

All responses (1)

Answers (0)

Suggested answer

YUN ZHU 68,242 Super User 2024 Season 2 on at

Like (0)

Report

RE: Retrieve Enum Caption In Query

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