• Replies 2 replies
  • Subscribers 337 subscribers
  • Views 67 views
  • Users 0 members are here
Related

Total tickets purchased by constituent

Phil McElfresh
$organization

Does anyone have a query or is there a report that would show lifetime tickets purchased sorted by dollar amount?  You would probably want to reduce by any ticket refunds.  We want something like:

ID 21314 Bill Smith $168,222

ID 1918 Jane Doe $144,326

etc.

 

Phil

  • $organization

    Your ticket history table may be customized but you can give this a whirl:

    select a.customer_no,sum(a.tck_amt) as total_dollars,b.fname, b.lname

    from lt_tkt_hist a

    join t_customer b

    on a.customer_no=b.customer_no

    group by a.customer_no, b.fname,b.lname

    order by total_dollars desc

  • $organization

    Thanks Dan!  I’ll give this a try. 

     

    My next question was going to be which table would be the best to query and I was thinking of the history table.

     

    Phil McElfresh
    IT Manager
    UApresents

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Dan Taraborrelli
    Sent: Friday, October 14, 2011 5:52 PM
    To: Mcelfresh, Phillip D - (philm)
    Subject: Re: [Tessitura Technical Forum] Total tickets purchased by constituent

     

    Your ticket history table may be customized but you can give this a whirl:

    select a.customer_no,sum(a.tck_amt) as total_dollars,b.fname, b.lname

    from lt_tkt_hist a

    join t_customer b

    on a.customer_no=b.customer_no

    group by a.customer_no, b.fname,b.lname

    order by total_dollars desc

    From: Phil McElfresh <bounce-philmcelfresh7978@tessituranetwork.com>
    Sent: 10/14/2011 5:01:02 PM

    Does anyone have a query or is there a report that would show lifetime tickets purchased sorted by dollar amount?  You would probably want to reduce by any ticket refunds.  We want something like:

    ID 21314 Bill Smith $168,222

    ID 1918 Jane Doe $144,326

    etc.

     

    Phil




    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!