Special Request notes?!

That’s great to hear Tiffany – think I will add it to the Output Set Cookbook when I get a chance.

;-)

Nice!

That works brilliantly!  Thank you Sandra. 

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

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  

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!

That’s great to hear Tiffany – think I will add it to the Output Set Cookbook when I get a chance.

;-)

Nice!

That works brilliantly!  Thank you Sandra. 

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

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  

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!