I do not retrieve the correct value, with a List of Values ​which depends on Cascading LOV Parent Item(s)

12 views Asked by At

with a List of Values ​​which depends on Cascading LOV Parent Item(s), when editing I do not retrieve the correct value. refreshing the list makes me lose my selected item

i have one item P1_TYPE which impacts the List Of Values P1_CODE with the PL/SQL

select
  display_value||' ('|| value_code ||')' as display_value,
  value_code 
    from data d
    inner join list l
        on l.list_id = d.list_id
    where list_name = :P1_TYPE

When i add a new Data, i don't have any problem but when i editing the popUp i think the list of values is refresed and i lost the values.

since the good value is also in DB, I wanted to recover it except that this may impact the fact that I am not in Edition.

0

There are 0 answers