Hello all,
Relatively new to extractions here. I am trying to pull a list/extraction for all Flex/CYO subscribers in the 2019-2020 Season. My criteria includes, Ticket History Season (20 Box Office) and Package History Price Type (all those that apply to CYO/Flex), however, this seems to pull any individuals that have ever purchased a CYO/Flex (and also purchased tickets in the 20 Box Office season). What I want is to extract constituents that have purchased CYO/FLEX WITHIN the 20 Box Office season. I've made multiple attempts and tried many variations without success. What am I missing?
Thanks!
You'll want to either remove Ticket History Season and replace it with Package History Season, or remove Package History Price Type and replace it with Ticket History Price Type. In a nutshell: the two criteria you're using now are pulling from different tables, which is why you're getting the result you described. Make sure both your criteria are from the same history and that should do it.
Success!!