Hi,
I have modified the LOV of an object to include ‘ALL’ in the list of values. the code is:
SELECT TABLENAME.COLUMNNAME
FROM
TABLE
UNION
SELECT ‘ALL’ FROM DUAL
While running the report, if i select ALL from LOV, there is no data returned. How do i tell BO that when i select ALL from LOV, it should include all the values associated with the object.
Thanks
raovala (BOB member since 2004-11-01)