Good day all,
We are instituting a new subscriber benefit such that a season ticket holder can upgrade all their tickets from one section to the next better section in the theatre once per season. In order to track whether a given subscriber has used the benefit we would like to add a customer service issue for all subscribers. To further complicate we would like subscribers with multiple seats to be able to use their upgrades in whatever combination they prefer for multiple shows and to allow them to be transferred to a friend's tickets.
The simplest method seems to be to write a local procedure to that will add a 'Seat Upgrade' customer service issue of a particular category and type to each constituent record in a given list. The list could be updated weekly or as necessary and the CSIs populated from the new list. I'm wondering if anyone out there has been down this path before and would like to share their experience and help me get started on writing a procedure? My sql is rudimentary at best--I'm trying to use this as a practical lesson.
Thank you,
Kyle Yandow
Hi Kyle, We have a form on our website where we needed to store the results in tessitura and create a CSI. What I did was use the WP_CREATE_ISSUE stored procedure as a starting point for our local procedure for creating CSIs.
Jon