Starting a thread dedicated to a topic we're all likely to be devoting a lot of time to.
Shall we also try using the Tags feature within it? Then folks can use it as a filter to narrow posts to one or the other. #CancellationProcessing and/or #CancellationMessaging
I'm thinking brilliant strategies (or hacks) or a place for questions that have you stumped.
To start, it off...
1) Cancellation email notice with web form with options about which route customer wants, exchange/donation/credit/refund. Easy for them; head start for your team.
2) If you are tokenized/don't save credit cards, pointedly call out somewhere in that messaging that your organization will calling to request the credit card number in order to process the refund.
Hi all, I am looking to pull a list of constituents with tickets to our four remaining (and cancelled productions). I would like the output set to include name, email, performance, performance date and order number. It has come to my attention that the order number output element would be a custom element. I am the only super-user at my organization, but don't know SQL. Any ideas on how to pull this information?
Hi Michelle!
You can do this without SQL! Here are some quick steps to set it up - let me know if anything gives you trouble!
1. Open your T_QUERY_ELEMENT System Table
2. Search for Ticket History Order Date (this is an out of the box one)
3. Select that row and copy it (the double paper icon right to the Red X delete button across the toolbar)
4. Edit the Description to say "Ticket History Order No"
5. Edit the Data Select column to say "!.order_no"
6. Save!
Then re-open the List Manager tool and you should be able to add Order No to your output elements, and then add a filter to only pull the Production Season(s) you want.
Hi Michelle, Have you tried running the Order Export Utility in the Ticketing Processing folder? That should give you everything you need.
That worked, thanks! The only different was the System table was TR_QUERY_ELEMENT.