BusinessObjects Board

Unable to get LOV for prompt condition present in subquery.

building reports desktopintelligence
#1

Hi,

I have a report that has a filter wich contains a subquery the logic is as mentioned below:

Select
a.col1,
b.col2,
c.col3
from
a,b,c
where
a.colu3=b.col5
and (c.col3=b.col6)
and (exits (select a.colu7
from
a,b,c,d
where
…some joins
and (a.name LIKE @Variable(Name))
))
group by
a.col1,
b.col2,
c.col3

The report is running fine, but my issue is that the LOV on prompt Name mentioned above does not work.

We tried fixing it in universe but it still does not work. We created a dummy prompt in the data provider using the same object a.Name it worked here but when we pull it in the subquery the lov disappears. :hb:

Please help!

zullehuma :india: (BOB member since 2008-08-04)

#2

Use @prompt() function giving the list of values, instead of @variable while creating the predefined condition for subquery in the universe

.

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

#3

Hi,

I tried using @prompt and it is even working fine, but then the prompt will not accept ‘matches pattern’ kind of values like “Smith%”, rather it will take multiple values and behave like ‘inlist’.

How to retain the original behaviour of the prompt (matches pattern-LIKE)?

Thanks

zullehuma :india: (BOB member since 2008-08-04)

#4

A search would have helped you…:slight_smile:

https://bobj-board.org/t/22218

Mak 1 :uk: (BOB member since 2005-01-06)

#5

Why not, like operator works with @prompt too

 Emp.Ename LIKE '%' || @Prompt('ENTER','A','Emp\Ename',,) || '%'

And as said earlier do this in the universe(along with the full sub-query) to enable list of values

.

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