Hi
Is it possible to have multiple parameters associated with an output set element but not have them all required? For example an element for total tickets purchased where the parameter could be season OR performance.
ThanksJess LevySan Francisco Operajlevy@sfopera.com
Since the criteria is still exclusive — that is, the element MUST choose a season or a performance, but not both and not neither, I would look at having both types of option in the same query element parameter. Your dropdown reference would be a view that UNIONS a select for performance with a select for season, and does something to ensure that their IDs don't overlap in the data column, like using odd vs. evens, or negatives vs. positives. Then in your query element where clause where you actually insert the parameter value, you would reference a column in a custom view that does the same kind of translation.
TBH though, if I were in the same position I would probably encourage the use of two separate output elements.