cancel
Showing results for 
Search instead for 
Did you mean: 

How to add 'ALL' as a list of value for the object?

Former Member
0 Kudos

Hello all,

I read many blogs for this option. I didn't understand how to Add  'ALL' as list of values for the objects in UDT/IDT?

Please let me know how to achieve it?

Regards,

Chandrakanth

Accepted Solutions (1)

Accepted Solutions (1)

former_member184582
Participant
0 Kudos

Hello Chandra,

In UDT/IDT edit the object for which you want to add ALL Option and add a query using union like

SELECT DISTINCT

RESORT.resort

FROM RESORT

UNION

SELECT ‘-ALL-’

FROM DUAL;

Resort In (Selection) OR ALL in (Selection)

When a resort is selected

Bahamas Beach In Bahamas Beach OR ALL In Bahamas Beach

The first half of the expression is true

When ALL is selected

ALL in Resort List OR ALL in ALL

The second half of the expression is true for every possible resort

( @Select(Resort\Resort) IN @Prompt('Please select

Resort','A','ALL

Components\Resort',multi,constrained) OR

@Select(ALL Components\ALL String) IN @Prompt('Please select Resort','A','ALLComponents\Resort',multi,constrained) )

Hope this will help you.

Former Member
0 Kudos

yes, understand 1st step:  Have to edit LOV of the objects and need to write SQL like below


"SELECT DISTINCT

RESORT.resort

FROM RESORT

UNION

SELECT ‘-ALL-’

FROM DUAL;"

Here, I added "All" to the list of values....Okie.

When i select "all" from lov's, how sql will generate?

My doubt ( i selected "all" but how webi engine will treat as combination of all the values in LOV's)

I am unable to understand. Please can u elaborate?

Regards,

Chandrakanth

Former Member
0 Kudos

So for selection on top of All you will have to create a universe prompt using @prompt like below which will ignore the prompt if ALL is selected..

here is a example for a Year prompt that we use.. Note already we have a LOV  Year which has the ALL value

And we have another object for year in time folder with where clause as below

Table.YEAR IN @Prompt('Enter Fiscal Year or ALL','A','Time\Year',Multi,Free) or 'ALL' IN  @Prompt('Enter Fiscal Year or ALL','A','Time\Year',Multi,Free,Persistent,{'ALL'})

and select clause as

Table.YEAR

Now we have another prompt referring the already created object..

ALL' IN  @Prompt('Enter Fiscal Year or ALL','A','Time\Year',Multi,Free,Persistent,{'ALL'}) or TABLE.YEAR IN @Prompt('Enter Fiscal Year or ALL','A','Time\Year',Multi,Free)

Once the prompt is created you can just use the prompt in your reports

Also check this thread which describes the same process

Answers (0)