• Replies 15 replies
  • Subscribers 420 subscribers
  • Views 259 views
  • Users 0 members are here
Related

Order Special Requests Reporting

Charles Buchanan
$organization

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

  • $organization

    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.

  • $organization

    Amanda,

     

    Could you share those reports with me as well?

     

    Thanks,

     

    Elizabeth Carlock

    Director, Ticketing Services

    The Granada Theatre 

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Amanda Freeman
    Sent: Thursday, November 10, 2011 3:01 PM
    To: Elizabeth Carlock
    Subject: Re: [Tessitura Ticketing Forum] Order Special Requests Reporting

     

    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.

    From: Charles Buchanan <bounce-charlesbuchanan5408@tessituranetwork.com>
    Sent: 11/10/2011 4:28:22 PM

    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




    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!

  • $organization

    I am in urgent need of this report as well.

    Florence

  • $organization

    Hi 

    Does anyone know if this report was shared on TASK?

    Thanks 

    Nicola 

  • $organization in reply to A. Freeman

    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.

  • Former Member
    Former Member $organization

    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!

  • $organization

    Order special requests are stored in T_SPECIAL_REQ.

     

  • $organization in reply to Jonathan Smillie

    Is there a way to pull in the special request receipient into a ticket design element?

  • $organization in reply to A. Freeman

    Hi Amanda,

    So you still have these reports available? If so, could you share them with me?

  • $organization

    Hi Amanda

     

    Can you let me know if you share you reports, it sounds like what we are looking for and will get us started!

     

    Many thanks

     

    Nicola

     

    Nicola Cawkwell

    Ticket Sales Manager

    Theatre Royal & Royal Concert Hall

    Theatre Square

    Nottingham NG1 5ND

     

    0115 721 0693

    nicola.cawkwell@nottinghamcity.gov.uk

    www.trch.co.uk

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Kari Daly
    Sent: 16 January 2013 19:19
    To: Nicola Cawkwell
    Subject: Re: [Tessitura Ticketing Forum] Order Special Requests Reporting

     

    Hi Amanda,

    So you still have these reports available? If so, could you share them with me?

    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!

    Sign up to the City Council's Flexible Fitness membership scheme and enjoy ?50 cashback and no joining fee, saving you ?80! To get fit for less visit www.mynottingham.gov.uk/flexiblefitness

    This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal

    This e-mail (and any attachments) is confidential and may
    contain personal views which are not the views of
    Nottingham City Council unless specifically stated.
    If you have received it in error, please delete it from
    your system, do not use, copy or disclose the information
    in any way nor act in reliance on it and notify the sender
    immediately. Please note that Nottingham City Council
    monitors e-mails sent or received for the purposes of
    ensuring compliance with its policies and procedures.
    Further communication will signify your consent to this.
    The contents of e-mails sent or received may have to be
    disclosed if a relevant request is made under current
    legislation, such as, but not limited to, the Data Protection
    Act 1998 and the Freedom of Information Act 2000

  • $organization in reply to Nicola Blackburn

    Hi Kari and Nicola,

     

    I wrote the report (and post) mentioned above in my previous position at La Jolla Playhouse. You could try asking someone there.

  • $organization

    Does anyone know if this was posted to TASK? Or would someone be able to send me the report that was created?

     

    Thanks!!

    Lauren

  • $organization

    Hello all,

    New adapters here hoping this long-dormant thread still has a few people that can help out.  We looking to do the same sort of functionality described in the original post.  Is anybody willing to share the custom report that was distributed in this thread?

    Thanks,

    --Gary

    gary.corneil@parl.gc.ca

  • $organization in reply to Gary Corneil

    Hi Gary, did you get any responses regarding the custom report, I too am after such a thing. 

    Thanks, Morgan 

    morgan.merrell@sydneysymphony.com

  • $organization
    HI Morgan,
     
    Not sure if Pim mentioned it to you, but I said we would look at getting that information in a report. He has briefed me on what he would like.
    So, we should be able to extract it internally.
     
    Cheers.
     
    Lynn McLaughlin
    Head of CRM
    P (02) 8215 4617
    M 0408 164 376
    Clock Tower Square, Cnr Harrington & Argyle Streets,
    The Rocks NSW 2000 Australia