Using LOV Lst name in condition

building semantic layer
1

Hi All,

I Have one object that contain Only one value in it LOV. I wish that object in one condition(like as a stop date), when i am givng the object name the condition throws an error at report level. Can you let me know is it possible to use lov list name directly in the condition(ie in sql editor)

Thanks in Advance

satyapeddi :india: (BOB member since 2011-01-10)

2

Hi,

What kind of error is it?

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

The error is “A database error occured. The database error text is: ORA-01722: invalid number
. (WIS 10901)”

satyapeddi :india: (BOB member since 2011-01-10)

4

Hi,

Can you also post the syntax of the condition? Or better, post the final SQL statement that WebI/DeskI generates. Or post both :slight_smile:

Marek Chladny :slovakia: (BOB member since 2003-11-27)