Value List - Get Enum Index Value

Unknown

Value List - Get Enum Index Value

Unknown

Hi

In version 5 we used to be able to take an Enum (Value List) and output its numeric value. Now it does not work - it always outputs the Display Name for both DisplayName and Value properties. Is there a new way to obtain this?

Thanks

Unknown

Hi,

One way to get the index value of a Value List is to use the Raw SQL Step. You can find an example SQL statement below. Please refer attached screenshots for your reference.

SELECT value_name, enum_order FROM datatype_enumvalue
where enum_data_type = Your Value List Name Space and Name Here

Regards

[img]att1[/img]

[img]att2[/img]