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
I've been running this around in my head, specifically looking at the somewhat gruesome Ticket History generating procedure, which uses three loops just to output one row per row of seats. My first concern, though, is what the character limit for values sent to Wordfly is.
The functions I created for my reports shamelessly rip off those loops plus a few little custom things specific to our venue set-up. And, much as I would like to believe there is a better way around it, I am just not sure there truly is given the vast number of different ways tickets could appear on any given account. You have to basically just gather them all up together first and then just start going through each of them.