I am trying to find patrons who have a ticket to every concert in our orchestral season. They would have to have multiple subs in order to accomplish this as there is no package that includes them all. Is there a why to do this with an extraction?
I already tried finding it with the a script, but I came up with 6 patrons and was told that can't be correct. I queried the vs_ticket_history view, and filtered by season.
Ashley Elliott
Database Administrator
St. Louis Symphony Orchestra
314-286-4198
ashleye@slso.org
I'm glad to see that you were able to get this figured out! Just for future reference, I wanted to summarize a few things about how criteria sets work when it comes to AND vs OR and throw in a link to some video resources to help illustrate the concepts.
When you make multiple selections from a criteria value dropdown, they are always joined by OR, meaning a constituent has to have just one of the values in the dropdown but not all of the values. When you are looking for someone who has all the values, you have to add the criterion multiple times to the set, using HAS as the operator, and making just one selection from the dropdown for each row.
You can find a video training series on lists and criteria here: https://www.tessituranetwork.com/Support/Training/Intro-Courses/Lists-and-OutputLessons 3 and 4 cover how criteria work together and the differences between IN and HAS.
Good job getting your query sorted, and thanks Gawain and Heath for being such helpful neighbors (in this and many other forum posts).
-Kevin