Dear friends, I have an interactive grid for Oracle APEX 5.1 and one of its columns has an LOV.
This LOV is based on a SQL query which invokes, among other criteria, a package.function with parameters such as : CD_ITEM1 and : CD_ITEM2 from other columns at the same interactive grid, as well as : P1_CD_PARAMETER and : P2_CD_PARAMETER which are page items.
It should pop up a LOV which displays, for example, 1, 2, 3 depending on parameters at one row, and 4, 5, 6 depending on parameters at another row.
However, this LOV does not seem to work - it does not filter any value in any column and it brings all LOV values for each row. Do you know any reason for that?
Thanks in advance.