I have set up a Parameter Query to build a query based on one selection from two separate lists....and would like to determine if and how to select multiples or all from each list...
My Parameter Query currently lets me select from an issue status list, i.e. active, pending, completed...
Then I select an issue owner, such as Tim or Pat ...and run the query delivering the desired information about Tim's Active Issues or Pat's Completed Issues...etc.
What I am seeking to do is be able to use a single query to select either one, multiple or all from each list.
With this capabilty, I could query all of Tim's Active and Completed Issues or Tim and Pat's Completed Issues or all of Tim's Issues.
Am I trying to use the Parameter Query outside its capabilities, or have I just not figured out the correct syntax? The Parameter Query seems to be expecting an exact literal match with the names in each list, so Tim and Pat doesn't work, nor does Tim, Pat.
Any suggestions on using a Parameter Query for this purpose? Or other ideas? An obvious (though cumbersome) solution not using a Parameter Query would be to build a query matrix with all possible solutions...but I figure it's got to be easier than that.
Thanks,
Dboyce
My Parameter Query currently lets me select from an issue status list, i.e. active, pending, completed...
Then I select an issue owner, such as Tim or Pat ...and run the query delivering the desired information about Tim's Active Issues or Pat's Completed Issues...etc.
What I am seeking to do is be able to use a single query to select either one, multiple or all from each list.
With this capabilty, I could query all of Tim's Active and Completed Issues or Tim and Pat's Completed Issues or all of Tim's Issues.
Am I trying to use the Parameter Query outside its capabilities, or have I just not figured out the correct syntax? The Parameter Query seems to be expecting an exact literal match with the names in each list, so Tim and Pat doesn't work, nor does Tim, Pat.
Any suggestions on using a Parameter Query for this purpose? Or other ideas? An obvious (though cumbersome) solution not using a Parameter Query would be to build a query matrix with all possible solutions...but I figure it's got to be easier than that.
Thanks,
Dboyce
