Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IG LOV column Sql*Query using other column's value

seanzhJun 6 2025 — edited Jun 6 2025

Hi, everyone,

Apex is 24.4.5.

I have one IG column of LOV type based on SQL*query. Cart_SEQ is primary key for this table, what I want is that this LOV shows all other ship dates except the one in current row, please see screen shot.

P28_SEQ is a hiden page Item whose value is assigned by IG row selectionChange DA, as now the query returns nothing because LOV init precedes this assignment, I basically got all ship dates( one too many) or nothing. Any suggestions? thank you

select shipdate D, cart_seq R from cart_dates_view where scannum=:P28_SCANNUM and cart_seq<>:P28_SEQ

Screenshot 2025-06-06 at 2.45.40 PM.png

This post has been answered by Karel Ekema on Jun 6 2025
Jump to Answer
Comments
Post Details
Added on Jun 6 2025
4 comments
91 views