Hi All,
I have created a multi select Prompt showing the list of values to the user.
and i would like to add a “ALL” option in list of values which when selected by user will retrieve all the data.
Hi Create on user object at universe level and put ‘All’ in the select defination property of the object.
and then you can map tha same object with or condition with the prompt.it will allow user to chosse any thing or user can type All and get all the records.
There are two approaches - overriding the LOV SQL, and creating a universe object.
Overriding the LOV SQL
Press the SQL button in the query panel of the LOV
Add the phrase UNION SELECT ‘ALL’ FROM DUAL or similar dummy table for your particular database. For SQL Server (if you don’t care if the object parses or not) add SELECT xx From xx UNION SELECT ‘ALL’ (You don’t need a FROM table)
Click the “Do not generate SQL before running” checkbox.
Universe Object
Create a universe object defined as a constant ‘ALL’
Associate it with the SYS.DUAL or equivalent table so it will parse (optional)
Press the combined query button in the query panel of the LOV (defaults to UNION)
Include the new universe object.
it is working…
but user should type in “ALL” to get the data for all values.
i would like to get "ALL’ in the LOV’s so that user can select it instead of typing.
Press the SQL button in the query panel of the LOV
Add the phrase UNION SELECT ‘ALL’ FROM DUAL or similar dummy table for your particular database. For SQL Server (if you don’t care if the object parses or not) add SELECT xx From xx UNION SELECT ‘ALL’ (You don’t need a FROM table)
Click the “Do not generate SQL before running” checkbox.
We’ve have been using a method like this for a while in BO 6.5. The prompt still works in BO XI r2 Desktop Intelligence.
However, when I try and get the prompts in Infoview, it doesnt work. It just seems to hang for ever. Anyone else use this method or know an alternative?
I have created an object to return ‘All’ and UNIONED this in the LOV for our “Name” object. We are then using a predefined filer with the following:
@Select(Contact\Name(All)) in @Prompt('Please select Name or ALL',A,
'Contact\Name (All)',Multi,FREE)
OR '*ALL*' in
@Select(Contact\Name(All)) in @Prompt('Please select Name or ALL',A,
'Contact\Name (All)',Multi,FREE)