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
