Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4
Does anyone have a custom report that pulls information from the “Special Requests” entered for the line item within a ticket order and would you be willing to share that with us? I would like a report that pulls Const ID, Order number in addition to the details from the line item: Event, Section, Row, Seats and the category and notes from the Special Request. This would not be for packages but for single ticket orders.
Thank you!
Charles Buchanan
Associate Director of Ticket Services
The Public Theater
425 Lafayette Street | New York, NY 10003
(212) 539-8676
I have a stored procedure that searches all tables in a database for a text string.
Syntax is similar to LP_SEARCH_ALL_TABLES ‘search_string’
It has helped me many times find where data is stored in Tessitura.
It would require a little tweaking for your environment.
If you’d like it, send me an email to:
wbaskin@basshall.com
I’ll send it in *.txt format.
Wendell Baskin
Performing Arts Fort Worth
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of trilandmcconico7946 Sent: Friday, October 19, 2012 12:21 To: Wendell Baskin Subject: Re: [Tessitura Ticketing Forum] Order Special Requests Reporting
Hi, would you share that report with me as well. I need to findout what table the special requests are housed in. Can someone let me know.
From: Amanda Freeman <bounce-amandafreeman5080@tessituranetwork.com> Sent: 11/10/2011 5:00:12 PM
I have almost that. It's everything about the SR except the actual seat location, does include zone though. I also have a "Special Request Recipient" custom screen if you're interested. Either might be a decent jumping point, if not exactly what you need.
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!