Hi,
Please I want to add all in the lovs so a user can just chose “All” without having to chose ever single value.
Database is oracle 11G
thanks
Alex.bo (BOB member since 2012-04-27)
Hi,
Please I want to add all in the lovs so a user can just chose “All” without having to chose ever single value.
Database is oracle 11G
thanks
Alex.bo (BOB member since 2012-04-27)
Hi,
This Designer’s FAQ will help:
Marek Chladny (BOB member since 2003-11-27)
First of all I got into the properties of the dimension object Year. Then under the edit option as soon as I click the combined query option, another query is generated and the queries, query1 and query2 are unioned. Then I got into the SQL of the combined queries generated. I replaced the SQL of the query2 with UNION SELECT ALL. Do not forget to check the checkbox Do not generate SQL before running. Finally I got back to the properties section, went into the Display option and refreshed the values. Now you can see a value by name ALL added to the list of values of the object Year.
Next, I created a filter object with a where clause as
@Select (Class\Object) In @Prompt (‘Message’,‘A’,‘Class\Object’, Multi, Free, Persistent) or ’ ALL’ IN @Prompt (‘Message’,‘A’,‘Class\Object’, Multi, Free, Persistent)
Here, the OR operator gives user the functionality of either selecting the LOVs individually or selecting the value ALL to display all the values together. You can define All as anything u want.
Thanks & Regards,
Afaf.
AFAF (BOB member since 2012-07-13)
There are two approaches - overriding the LOV SQL, and creating a universe
object.
Overriding the LOV SQL
Universe Object
Thanks.
Abdullah Irfan
Abdullah Irfan (BOB member since 2012-08-24)
edit solved: i checked export with universe in object properties to get it work
Thanks
Hi i followed both of aforementioned approach
and i can see ‘all’ in when i display lov on universe leve using both approach.
but i cant get that lov in wei rich client or thin client.
confused seems real easy and working in universe but when i drop this condition in query filter LOV dosent have ‘All’ what could be reason
anybody
broccolimustdie (BOB member since 2010-06-17)
Perhaps you can use an optional prompt as well?
Jurr (BOB member since 2011-08-24)
Is this issue resolved ???
AFAF (BOB member since 2012-07-13)