I have several objects using nvl(Object,‘Unknown’) and I would like to be able to select ‘Unknown’ from the List of Values.
What’s the easiest way to do this?
MichaelRo1 (BOB member since 2004-05-11)
Hi Michael,
Are you using it in all the objects select statement?
GNK_BO (BOB member since 2007-07-17)
Not sure what you mean by that?
MichaelRo1 (BOB member since 2004-05-11)
It should be happening already. If that’s the object select clause, then the LOV should be using the same thing, therefore “Unknown” will show up.
Dave Rathbun 
(BOB member since 2002-06-06)
It doesn’t
The Object is a ‘Lookup’ table object.
This connects to the main data table with a left outer join.
The Lookup table has a self restricting join.
If I query on the object itself it doesn’t appear in the LOV
SQL = SELECT
nvl(LU_ACTIVITY.DESCRIPTION,‘Unknown’)
FROM
USERCODE LU_ACTIVITY
WHERE
( LU_ACTIVITY.DOMAINKEY(+)=‘ACT’ )
MichaelRo1 (BOB member since 2004-05-11)
Have you see this FAQ entry about adding 'All" to the list? The same technique should work for this.
Dave Rathbun (BOB member since 2002-06-06)