• Replies 4 replies
  • Subscribers 415 subscribers
  • Views 150 views
  • Users 0 members are here
Related

report that gives ticket numbers?

Tommy Looney
$organization

Is there a report that will give the ticket numbers for an order?

I have an order where 100 tickets were printed but not scanned for a particular performance and I want to manually enter the ticket numbers to record attendance but I dont want to have to reprint the tickets and do it that way.

Parents
  • $organization

    We don't have a report but if you have somebody with access to Sql Server Management Studio, here is a query that will help.

     

     

    SELECT

        Distinct

        a.ticket_no

    FROM

        TX_SLI_TICKET a Join

        T_SUB_LINEITEM sl on sl.sli_no = a.sli_no

    where

        sl.order_no = @Order_no

        and sl.sli_status = 12

     

    Marty

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Tommy Looney
    Sent: Saturday, November 21, 2009 5:37 PM
    To: Martin A. Jones
    Subject: [Tessitura Ticketing Forum] report that gives ticket numbers?

     

    Is there a report that will give the ticket numbers for an order?

    I have an order where 100 tickets were printed but not scanned for a particular performance and I want to manually enter the ticket numbers to record attendance but I dont want to have to reprint the tickets and do it that way.




    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

    We don't have a report but if you have somebody with access to Sql Server Management Studio, here is a query that will help.

     

     

    SELECT

        Distinct

        a.ticket_no

    FROM

        TX_SLI_TICKET a Join

        T_SUB_LINEITEM sl on sl.sli_no = a.sli_no

    where

        sl.order_no = @Order_no

        and sl.sli_status = 12

     

    Marty

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Tommy Looney
    Sent: Saturday, November 21, 2009 5:37 PM
    To: Martin A. Jones
    Subject: [Tessitura Ticketing Forum] report that gives ticket numbers?

     

    Is there a report that will give the ticket numbers for an order?

    I have an order where 100 tickets were printed but not scanned for a particular performance and I want to manually enter the ticket numbers to record attendance but I dont want to have to reprint the tickets and do it that way.




    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