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
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
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?!
From: Tiffany Evans <bounce-tiffanyevans7088@tessituranetwork.com> Sent: 9/12/2013 3:17:17 PM
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!
This is from a past post. Try contacting someone at La Jolla.
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.
Thanks, Amanda. J
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Adria Gunter Sent: Thursday, September 12, 2013 5:31 PM To: Tiffany Evans Subject: RE: [Tessitura Ticketing Forum] Special Request notes?!
Amanda Freeman JCA
Posts 601
replied on 01-17-2013 2:14 PM
Reply
From: Tiffany Evans <bounce-tiffanyevans7088@tessituranetwork.com> Sent: 9/12/2013 3:56:02 PM
Oh Sorry... I meant the Special Request notes. I can see the ORDER notes (the field in the header of the order screen) in the order export, but not the special request notes.... -----Original Message----- From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Nichole Mines Sent: Thursday, September 12, 2013 4:51 PM To: Tiffany Evans Subject: RE: [Tessitura Ticketing Forum] Special Request notes?! You can use the order export utility to get the info. Sent from my Galaxy S®III -------- Original message -------- From: Tiffany Evans Date: 09/12/2013 1:25 PM (GMT-08:00) To: Nichole Mines Subject: [Tessitura Ticketing Forum] Special Request notes?! 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! 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! 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!
I also contacted our Database consultant and gave him your email address. He may be sending you some coding.
Adria
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Tiffany EvansSent: Thursday, September 12, 2013 5:58 PMTo: Adria GunterSubject: RE: [Tessitura Ticketing Forum] Special Request notes?!
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Adria GunterSent: Thursday, September 12, 2013 5:31 PMTo: Tiffany EvansSubject: RE: [Tessitura Ticketing Forum] Special Request notes?!
From: Tiffany Evans <bounce-tiffanyevans7088@tessituranetwork.com>Sent: 9/12/2013 3:56:02 PM
Oh Sorry... I meant the Special Request notes. I can see the ORDER notes (the field in the header of the order screen) in the order export, but not the special request notes....-----Original Message-----From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Nichole MinesSent: Thursday, September 12, 2013 4:51 PMTo: Tiffany EvansSubject: RE: [Tessitura Ticketing Forum] Special Request notes?!You can use the order export utility to get the info.Sent from my Galaxy S®III-------- Original message --------From: Tiffany Evans Date: 09/12/2013 1:25 PM (GMT-08:00)To: Nichole Mines Subject: [Tessitura Ticketing Forum] Special Request notes?!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 EvansDatabase CoordinatorHuntington Theatre CompanyThis 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!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!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!
I also contacted our Database consultant and gave him your email address. He may be sending you some coding. Adria From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Tiffany Evans Sent: Thursday, September 12, 2013 5:58 PM To: Adria Gunter Subject: RE: [Tessitura Ticketing Forum] Special Request notes?! Thanks, Amanda. J From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Adria Gunter Sent: Thursday, September 12, 2013 5:31 PM To: Tiffany Evans Subject: RE: [Tessitura Ticketing Forum] Special Request notes?! This is from a past post. Try contacting someone at La Jolla. Amanda Freeman JCA Posts 601 replied on 01-17-2013 2:14 PM Reply 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. From: Tiffany Evans <bounce-tiffanyevans7088@tessituranetwork.com> Sent: 9/12/2013 3:56:02 PM Oh Sorry... I meant the Special Request notes. I can see the ORDER notes (the field in the header of the order screen) in the order export, but not the special request notes.... -----Original Message----- From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Nichole Mines Sent: Thursday, September 12, 2013 4:51 PM To: Tiffany Evans Subject: RE: [Tessitura Ticketing Forum] Special Request notes?! You can use the order export utility to get the info. Sent from my Galaxy S®III -------- Original message -------- From: Tiffany Evans Date: 09/12/2013 1:25 PM (GMT-08:00) To: Nichole Mines Subject: [Tessitura Ticketing Forum] Special Request notes?! 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! 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! 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! 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! 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!
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Tiffany Evans Sent: Thursday, September 12, 2013 5:58 PM To: Adria Gunter Subject: RE: [Tessitura Ticketing Forum] Special Request notes?!
You could connect T_SPECIAL_REQ to T_LINEITEM then to T_ORDER to get to the customer_no and to make an Output set Element
Something like this should do the trick.
select c.customer_no, isnull(a.notes,'') from T_SPECIAL_REQ a
join t_lineitem b on a.li_seq_no = b.li_seq_no
join T_ORDER c on b.order_no = c.order_no
Cheers
Sandra
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Tiffany Evans Sent: Friday, 13 September 2013 7:03 AM To: Sandra Ashby Subject: RE: [Tessitura Ticketing Forum] Special Request notes?!
Nice!
That works brilliantly! Thank you Sandra.
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Sandra Ashby Sent: Friday, September 13, 2013 2:32 AM To: Tiffany Evans Subject: RE: [Tessitura Ticketing Forum] Special Request notes?!
Are you guys using SQL Management Studio? I want to learn SQL so I can solve problems like this one on my own.
Glad you got a solution.
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Tiffany EvansSent: Friday, September 13, 2013 5:51 PMTo: Adria GunterSubject: RE: [Tessitura Ticketing Forum] Special Request notes?!
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Sandra AshbySent: Friday, September 13, 2013 2:32 AMTo: Tiffany EvansSubject: RE: [Tessitura Ticketing Forum] Special Request notes?!
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Tiffany EvansSent: Friday, 13 September 2013 7:03 AMTo: Sandra AshbySubject: RE: [Tessitura Ticketing Forum] Special Request notes?!
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Adria GunterSent: Thursday, September 12, 2013 4:39 PMTo: Tiffany EvansSubject: Re: [Tessitura Ticketing Forum] Special Request notes?!
From: Tiffany Evans <bounce-tiffanyevans7088@tessituranetwork.com>Sent: 9/12/2013 3:17:17 PM
That’s great to hear Tiffany – think I will add it to the Output Set Cookbook when I get a chance.
;-)
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Tiffany Evans Sent: Saturday, 14 September 2013 7:56 AM To: Sandra Ashby Subject: RE: [Tessitura Ticketing Forum] Special Request notes?!