Prompt generates bad SQL

[GMACTom]

I have a set of filters from which to choose.
I have a defined search that will pick certain categories of filters: a "White" and a "Green" and a "Yellow" search.

I am trying to create a "White" prompt that will allow user to select one or more "White" filters at report execution time. This type of prompt allows users to choose one or more objects. I use the results of the search object. Web option is list multi-select. Prompt answer is required.

I create a report and add this prompt to the filter. I run report and select "White January" and "White February" filters from the prompt. The SQL generated looks like
where col = "White January" and col = "White February"
which returns no result of course. Should be OR not AND there but obviously something else is happening here that I do not understand.

Can anyone help me understand what is gpomg on, and suggest a way to make this filter do what I need? If I need to supply more information I will be glad to. Thanks for any ideas.

MicroStrategy 7.2.1 on Win 2000, Oracle 8i on AIX.

 

[nlim]

I would combine all your "white Jan", "white Feb" filters into one "white mon" filter. Do this by creating an attribute qualification prompt. When you pick this "white mon" filter, you can then pick Jan and Feb.

The SQL will issue an IN clause.