ALL in LOV

[system]

Hi I just want to add this topic as I found topic related to usage of All in LOV is not explained clear.

Step 1. Include ‘All’ in object definition using UNION key word. Check Do not generate SQL before running option.
eg. select ‘All’ from dual for oracle; select ‘All’ for sql server;
Save the object and close it.

Step 2: define a filter as below on same object where you included ‘All’
@select(class\object) in prompt(‘Prompt’,‘data type’,‘class\object’,multi,free) or ‘All’ in prompt(‘Prompt’,‘data type’,‘class\object’,multi,free)

Parse it

Now use these objects in report. you ll see results as expected. Please do mail me if any mistakes in this.

Thank You
Sridhar Koilada

---

koilada (BOB member since 2007-04-03)

[system]

It works fine.

---

KP_Pani (BOB member since 2007-05-03)

[system]

Thanks for the solution.

FAQ Designer also contains the solution. But definitely your post will help others…

Posts By: Cindy Clayton and Dwayne Hoffpauir (in FAQ Designer).

---

aniketp (BOB member since 2007-10-05)