Dear sirs,
I use Popup LOV in Interactive Grid.
If return value of LOV is NUMBER, the Interactive Grid's search ignores the display column of the LOV.
Sample Application: https://apex.oracle.com/pls/apex/f?p=105446:1:11171254418828::::: - search for "Yes" gives no result (but should).
Detailed description:
Dummy LOV is defined as :
select 'Yes' as d,
1 as r
from dual
union
select 'No' as d,
0 as r
from dual
where return column r has NUMBER datatype.
Interactive Grid
select object_name,
decode(editionable,'Y',1,'N',0) as edit_1_0
from user_objects
uses Popup LOV based on LOV described above for edit_1_0 - column.
Search for "Yes" should show all editinable objects, but displays nothing.....
Apex 19.2 with APEX_19_2_0_PATCH_30392181.
Regards,
Pavel