APEX Interactive Grid Exports Wrong Value For Cascading LOV (Doc ID 2285083.1)

Last updated on JULY 14, 2017

Applies to:

Oracle Application Express (formerly HTML DB) - Version 5.1.0.00.43 to 5.1.0.00.43 [Release 5]
Information in this document applies to any platform.

Symptoms

When downloading the data (CSV or HTML) from an Interactive Grid that has a cascading LOV in it, the column that has the cascading LOV displays the return value instead of the display value.

For eg:  the country column is downloaded with the values from countries.country_id.
Expected behavior is to display the values from countries.country_name, as per the LOV that has been configured for that column.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms