Hi ALL,
I have read the discussion box abt this topic and i follwed the indtructions they gave and now i can able to see the ‘ALL’ in my LOV’s but when i pull that column and select ‘ALL’ i dnt get any data back.It says
“No Date Fetch”
My variable is Account ,i need users to select ‘ALL’ if they dnt want to mention specific account and i want them to see all accounts.
Is there any way that i dnt create a prompt for this variable just pulling the variable in querry pannel and selecting 'ALL' from LOV?
These are the steps i found in forum and follwed:
The steps I followed:
-
Create an object with the below code in the select clause:
Code:
’ All’ -
Click on the Associated Tables present at the right hand bottom side, and select the table name(any table from which you are fetching your column and you want to see “all” in that column)
-
Suppose you have an object “Name” and you want All with this and this “Name” is coming from “XYZ” Table Name. So in this case, in the second step you need to associate your All object with the XYZ table.
-
Go to the properties tab of this object and then click on Edit.
-
The query panel will appear. You will see there is a name object. So now click on Combined queries button and then add " All" object in that combined query. Perform Union Operation between Name and All object.
-
Check the SQL, you will see
madhu@P (BOB member since 2008-08-04)