Hi all,
Has anyone come up with a good custom view to display seat location information specifically for use in WordFly? I've got one built out that works perfectly for front and back end use in Tessitura, but we are struggling to come up with a solution that addresses those edge cases that cause a patron to have multiple rows of data when it comes to seat location info. For example, patrons who have tickets to multiple performances in the same production/run, patrons who have blocks of seats in 2+ areas/levels of the house, patrons with non-contiguous seats, etc. - we aren't sure how to best get this information to display in a single line of data in a way that is clear and clean. We specifically want to pull this information into our pre-show emails, which we run on a per production basis (rather than per performance). We've spoken to WordFly's support team about this, but they have been pretty insistent that this must be addressed on the Tessitura end.
Thanks!
Lauren
Yep.
Specifically, it takes and order and concatenates, performance name, date, seat row/number etc, with some html in a "stuff for XML path" and then loops for as many line items (or is it SLI ... I can check) with a carriage return for each new line. This whole thing gets wrapped up in one single output set element of course so you can pull it through to your email in a single line of output set data - dispensing with the multiple rows.
You can do a confirmation or preshow from it. I created it in COVID as we had a GA performance that we were required to seat in fixed numbered seats after the original booking.
It's pretty basic and it's a trick that many peeps use for a variety of things. My Analytics Manager is a bit of a genius and did similar (for Gift Certificates) into a table.
Is that what you are after? Essentially you can take the ticket history info grouped around Order ID (or perf ID) and stuff them together with a new line after every new line.
Cheers,H