How do I get display value of a property via ODBC
I have a class with a string property with DISPLAYLIST and VALUELIST parameters specified.
When I query this class via ODBC I receive logical value as it is and not a display value.
Is there any way (without stored procedure) to get display value?
I found out that %EXTERNAL can do it.
I am not a fan of this behavior but the LogicalToOdbc method does not convert the ValueList to DisplayList like the LogicalToDisplay method does.
You have 2 Options:
1) you can use %External(FieldName) in the query, that will give you the DislayList value
2) you can write your own LogicalToOdbc method that does the same as the LogicalToDisplay does
Thank you!