One of my users is attempting to use Lists and Output Set Builder to pull some ticketing information. The list works properly, and pulls only the customers that bought from the selected performances.
The problem comes in with Output Set Builder pulling all ticket history for those users. I realize I can probably set up TR_QUERY_ELEMENT and TR_QUERY_ELEMENT_PARAMETER (if I knew how) to filter to the correct performances, but that would require selecting the same performance data twice, once in the list, and once in Output Set Builder.
Is there a better way?
Heather Laidlaw Kraft SEATTLE REPERTORY THEATRE Please consider the environment before printing this e-mail
I asked a question about unwanted ticket lines in query output a while back and Sandra Ashby gave me a great tip; when you set up your composite query item use an unusual character as a break between each element, we use ~ and it means that when you save to Excel you can split the text to columns by this character. It works a treat and our member events co-ordinator was really pleased with the result.
It looks like this in practice (in case my explanation was rubbish)
Description: Ticket dt~Perf name~No seats
Data Select: cast(!.perf_dt as char (12)) + '~' + !.production + '~' + cast(!.tot_seats as char (3))