Examples of the object references all configured the same way: In all three cases, I get different results if I use the base property instead of a virtual property - even though all three base columns are decimal.
With base property:
region_id.description --> no errors, but returns 0 for every row
country_id.description --> throws "Datatype (Decimal) is not supported!"
emptype_id.description --> throws "Datatype (Decimal) is not supported!"
With virtual property converting base property to string:
VRT_region_idAsString.description --> no errors, but returns empty strings
VRT_country_idAsString.description --> works fine, returns populated strings
VRT_emptype_idAsString.description --> works fine, returns populated strings
Examples of the object references all configured the same way: In all three cases, I get different results if I use the base property instead of a virtual property - even though all three base columns are decimal.
With base property:
region_id.description --> no errors, but returns 0 for every row
country_id.description --> throws "Datatype (Decimal) is not supported!"
emptype_id.description --> throws "Datatype (Decimal) is not supported!"
With virtual property converting base property to string:
VRT_region_idAsString.description --> no errors, but returns empty strings
VRT_country_idAsString.description --> works fine, returns populated strings
VRT_emptype_idAsString.description --> works fine, returns populated strings
