OQL - get enumeration caption from attribute

Hi I am using an OQL query to export some data to excel and one of the attributes I am selecting is of type Enumeration. Is it possible to retrieve an enumeration's caption via an OQL query? Thanks iain
1 answers

It's not possible to retrieve the caption because it's not in the database. If you need it, create an entity and create columns for enum key and value and retrieve it with OQL.