I have the requirement in the report like user want’s to select one/more cities or if user want’s to select * then dispaly all cities info. in report.
‘*’ should be from list box only.
In universe object written like this. But me unable to see ‘*’ in the LOV.
If I enter * it working fine. But I want to show * along with all cities.
(@Select(Store\City)IN @Prompt(‘Select State or
enter * for all’,‘a’,‘Store\City’,multi,free) ) or
(’*’ in @Prompt(‘Select State or
enter * for all’,‘a’,‘Store\City’,multi,free) )
Please let me know , how to dispaly * in list box.
Create one object.In that select clause please enter ‘*’ and provide the reference table. this object contain the * value only
go to object in which object you want display the *
go to object properties and click edit
select combine query function in query pannel and provide that object which contains *.
select run and check in the display list
Note : You have to same assign the same data type for the created object
Please try with bellow logic and it will work fine
(@Select(Store\City)IN @Prompt(‘Select State or enter * for all’,‘a’,‘Store\City’,multi,free) )
or
(’*’ IN @Variable(‘Select State or enter * for all’ ) )
SELECT
table.column_name
FROM
table
UNION ALL
SELECT '*' from DUAL
If you want to bring the * to the top, you will need to wrap this up as an inline select:
SELECT c.colref
from
(
SELECT
table.column_name colref
FROM
table
UNION ALL
SELECT '*' from DUAL) c
ORDER BY CASE WHEN c.colref = '*' THEN 'aaaaa' ELSE c.colref END
NO,you have to assign one table for that object.Thats why it is giving that error.
you do one thing,you can assign any table.
1.after putting the ‘*’ in the select clause
2.select TABLES button and assign any table.
3. click ok
after above steps the object will create.
NOTE : this object will contain only * value
you can use this object and follow the steps what i provided previsoly