Skip to Main Content

APEX

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Popup LOV shows the same value in display and return value

I get the same display and return value when I specify the following SQL query in Popup LOV :

select distinct location_name as d, location_id as r from json_table(:P145_RESPONSE_JSON, '$.items[*]'
columns(location_name path '$.participants[*]?(@.actor.kind == "location").actor.name',location_id path '$.participants[*]?(@.actor.kind == "location").actor.id'))

Not quite sure why ?

If I swap location_id as display and location_name as return, it gives me the appropriate values although that's not what I want.

Any ideas to fix this.

This post has been answered by Subramaniam Shastri-Oracle on Feb 11 2024
Jump to Answer
Comments
Post Details
Added on Feb 11 2024
1 comment
39 views