Hello,
I have two query prompts. The first one will populate all the countries. Based on a country or a list of countries selected, the second query prompt will be populated with their respective posts.
My question is how would I create the list of values in the Information Design Tool so that I could pass prompt value from one Query Prompt to another.
I am using Business Objects 4.0 Service Pack 9.
Thanks
Singaram
kumaran22 (BOB member since 2010-07-14)
Are you doing this in Xcelsius/Dashboards? If so, there are two pretty straightforward solutions.
The first is to make two connections. One just returns the countries. The second doesn’t return anything initially. But when a selection is made from the first query (presumably through a combo box), the second connection is triggered. The selected country is passed as a prompt.
The second option is to use the Filtered Rows option. You create one query that returns the countries and related posts. The first combo box points to the list of countries as the labels. The data is filtered by the selection, and the related posts get written to another location, where the second combo box picks them up.
Lugh (BOB member since 2009-07-16)
I have done this before using a combo box. My problem is that the user can select all countries or multiple countries. Based on these selections, the second filter will need to retrieve all of the posts related to the first selection. The combo box does not allow you select multiple values or select all values. That is why I am using a Query Prompt.
kumaran22 (BOB member since 2010-07-14)
So have an option ‘All’ hardcoded on your dashboard and include it in the range for your country prompt. If the users selects it, pass a null back to the data source (or a country in a,b,c etc)
That’s the way I do it.
debbie
Debbie 
(BOB member since 2005-03-01)
Hi Debbi,
Thanks for the reply. How would a null value passed back to the data source actually bring back all the records for the next combo box. Again, when a user selects the ‘All’ value from the country combo box, the next combo box should populate all of the Posts.
Regards,
Singaram
kumaran22 (BOB member since 2010-07-14)
You pretend! Depends on your data source. Put a formula into a another cell that says if cell1=‘All’ then ‘1=1’ or whatever. Passing back 1=1 to a text query is equivalent to ALL. Or if you’re using a webi query and there aren’t too many counries, pass back a full string of all of them…
debbie
Debbie (BOB member since 2005-03-01)