• Replies 8 replies
  • Subscribers 338 subscribers
  • Views 172 views
  • Users 0 members are here
Related

Query to find people who attended a performance in a production more than once

Tiffany Elliott (Past Member)
$organization

Hi Tess friends,

I'm attempting to write a query to find patrons who have attended a performance in a production season more than once (a repeat buyer) and I'm having a heck of a time finding the table/view that I should be using.

At first, I thought it had to do with 'vs_tkt_hist" as that came up when I was experimenting in list builder, but I don't see that table anywhere in SSMS. 

Does anyone have any recommendations as to what table I should use?  Any idea what I might be doing wrong? Any help would be greatly appreciated. :)

 

Thanks,

Tiffany Evans

Database Coordinator

Huntington Theatre Company

Parents
  • $organization

    Thanks for your help, Gawain.

     

    It’s so strange…

     

    When I see the manual edit in List builder, it says vs_tkt_hist as the view to reference.

    However, in the system table TR_QUERY_ELEMENT, I can see VS_TCK_HIST and it’s in the data from column for the Tickets-Number of Unique Perfs (which is what I would use to see how many unique performances they saw).

     

    I think the query I just got from Chris works well.  Thank you all for your help. J

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gawain Lavers
    Sent: Monday, September 30, 2013 5:11 PM
    To: Tiffany Evans
    Subject: Re: [Tessitura Technical Forum] Query to find people who attended a performance in a production more than once

     

    Hi Tiffany,

    Do you mean the view VS_TCK_HIST?  I'm afraid Tessitura doesn't have the best record of consistency with naming/abbreviating conventions...

    --Gawain

    From: Tiffany Evans <bounce-tiffanyevans7088@tessituranetwork.com>
    Sent: 9/30/2013 3:34:25 PM

    Hi Tess friends,

    I'm attempting to write a query to find patrons who have attended a performance in a production season more than once (a repeat buyer) and I'm having a heck of a time finding the table/view that I should be using.

    At first, I thought it had to do with 'vs_tkt_hist" as that came up when I was experimenting in list builder, but I don't see that table anywhere in SSMS. 

    Does anyone have any recommendations as to what table I should use?  Any idea what I might be doing wrong? Any help would be greatly appreciated. :)

     

    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 Technical Forum. You may reply to this message to post to the Technical 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

    Thanks for your help, Gawain.

     

    It’s so strange…

     

    When I see the manual edit in List builder, it says vs_tkt_hist as the view to reference.

    However, in the system table TR_QUERY_ELEMENT, I can see VS_TCK_HIST and it’s in the data from column for the Tickets-Number of Unique Perfs (which is what I would use to see how many unique performances they saw).

     

    I think the query I just got from Chris works well.  Thank you all for your help. J

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gawain Lavers
    Sent: Monday, September 30, 2013 5:11 PM
    To: Tiffany Evans
    Subject: Re: [Tessitura Technical Forum] Query to find people who attended a performance in a production more than once

     

    Hi Tiffany,

    Do you mean the view VS_TCK_HIST?  I'm afraid Tessitura doesn't have the best record of consistency with naming/abbreviating conventions...

    --Gawain

    From: Tiffany Evans <bounce-tiffanyevans7088@tessituranetwork.com>
    Sent: 9/30/2013 3:34:25 PM

    Hi Tess friends,

    I'm attempting to write a query to find patrons who have attended a performance in a production season more than once (a repeat buyer) and I'm having a heck of a time finding the table/view that I should be using.

    At first, I thought it had to do with 'vs_tkt_hist" as that came up when I was experimenting in list builder, but I don't see that table anywhere in SSMS. 

    Does anyone have any recommendations as to what table I should use?  Any idea what I might be doing wrong? Any help would be greatly appreciated. :)

     

    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 Technical Forum. You may reply to this message to post to the Technical 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