How to use ALL in the where clause in prompts

building reports webintelligence
2

You already have the correct syntax to implement the ‘ALL’ for the prompt.
You will use this in a predefined condition in the universe, drag it into query panel which when prompted and ‘ALL’ typed in the box should fetch data for all values in the LOV.
Also read the Designer FAQ All in LOV

.

haider :es: (BOB member since 2005-07-18)