• Replies 12 replies
  • Subscribers 414 subscribers
  • Views 109 views
  • Users 0 members are here
Related

Special Request notes?!

Tiffany Elliott (Past Member)
$organization

Hi,

I'm looking for a way to view the special request notes from a list of patrons with orders and I'm having some trouble making this happen. 

I could have sworn there was a report somewhere that could do this, but I can't seem to find it. :-(

Any ideas? 

Thanks,

Tiffany Evans

Database Coordinator

Huntington Theatre Company

 

Parents
  • $organization

    I’m so close to figuring it out, but I’m still learning SQL.

    I know the table is T_SPECIAL_REQ and I know that TR_QUERY_ELEMENT can add criteria for outputs and lists, but I don’t think T_SPECIAL_REQ has a constituent_no, so it won’t work! L

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Adria Gunter
    Sent: Thursday, September 12, 2013 4:39 PM
    To: Tiffany Evans
    Subject: Re: [Tessitura Ticketing Forum] Special Request notes?!

     

    I spent an embarrassing amount of time trying to find something that pulled this. I ultimately had to have a database contractor pull the list for us with some SQL magic. He also created a category in our List Manager to use in the future. 

    Adria Gunter

    Studio Theatre-Washington, DC  

     

    From: Tiffany Evans <bounce-tiffanyevans7088@tessituranetwork.com>
    Sent: 9/12/2013 3:17:17 PM

    Hi,

    I'm looking for a way to view the special request notes from a list of patrons with orders and I'm having some trouble making this happen. 

    I could have sworn there was a report somewhere that could do this, but I can't seem to find it. :-(

    Any ideas? 

    Thanks,

    Tiffany Evans

    Database Coordinator

    Huntington Theatre Company

     




    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!

Reply
  • $organization

    I’m so close to figuring it out, but I’m still learning SQL.

    I know the table is T_SPECIAL_REQ and I know that TR_QUERY_ELEMENT can add criteria for outputs and lists, but I don’t think T_SPECIAL_REQ has a constituent_no, so it won’t work! L

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Adria Gunter
    Sent: Thursday, September 12, 2013 4:39 PM
    To: Tiffany Evans
    Subject: Re: [Tessitura Ticketing Forum] Special Request notes?!

     

    I spent an embarrassing amount of time trying to find something that pulled this. I ultimately had to have a database contractor pull the list for us with some SQL magic. He also created a category in our List Manager to use in the future. 

    Adria Gunter

    Studio Theatre-Washington, DC  

     

    From: Tiffany Evans <bounce-tiffanyevans7088@tessituranetwork.com>
    Sent: 9/12/2013 3:17:17 PM

    Hi,

    I'm looking for a way to view the special request notes from a list of patrons with orders and I'm having some trouble making this happen. 

    I could have sworn there was a report somewhere that could do this, but I can't seem to find it. :-(

    Any ideas? 

    Thanks,

    Tiffany Evans

    Database Coordinator

    Huntington Theatre Company

     




    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!

Children
No Data