I want to create cascading prompts with ‘All’ in the LOV? When i select ‘All’ it should give me all list of values.
I tried adding ‘All’ in the object properties “UNION
SELECT ‘All’ FROM SYSIBM.SYSDUMMY1” but this does not solve my purpose. Its not displaying all the list of values when ‘All’ is selected.
For oracle “Select ‘ALL’ from dual” will help. At the same time you should modify the prompt to make it understand that if you select ALL, then all the values in LOV should be selected.