• Replies 3 replies
  • Subscribers 246 subscribers
  • Views 8 views
  • Users 0 members are here
Related

GetZonesPerSection for Packages

Patrick FitzGerald
$organization

We are working on SYOS for subscriptions. We had hoped to use all the same API requests that we had used for single ticket SYOS, but discovered that Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 GetZonesPerSection does not take a package number as an input.


I'm curious if others have run into this same situation and what kind of workarounds you might have used.  Any thoughts would be appreciated.

Parents
  • $organization

    Hi Larry,

     

    Just a heads up--the network suggested that we use GetSeats or GetSeatsBrief, which do work with packages. If my memory serves me correctly, these methods can be very slow because they return all the seat data for the venue.

     

    We ended up writing a custom procedure; I can probably dig it up for you, if you are interested.

     

    Thanks,

     

    Patrick

     

     

    Patrick FitzGerald

    Technical Project Analyst
    The Pittsburgh Cultural Trust
    803 Liberty Avenue
    Pittsburgh, PA  15222
    fitzgerald@pgharts.org
    w 412-325-7061
    c 646-434-8955

     

     

     

    From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Larry Brindise
    Sent: Thursday, December 16, 2010 2:53 PM
    To: Fitzgerald, Patrick
    Subject: Re: [Tessitura Web Forum] GetZonesPerSection for Packages

     

    I was just going to post the exact same question.

    Does anyone have insight into this situation?

    Thanks,

    Larry

    From: Patrick FitzGerald <bounce-patrickfitzgerald8839@tessituranetwork.com>
    Sent: 7/14/2010 11:00:18 AM

    We are working on SYOS for subscriptions. We had hoped to use all the same API requests that we had used for single ticket SYOS, but discovered that Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 GetZonesPerSection does not take a package number as an input.


    I'm curious if others have run into this same situation and what kind of workarounds you might have used.  Any thoughts would be appreciated.




    You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web 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!

  • $organization in reply to Patrick FitzGerald

    Thanks.  I had already started writing a custom procedure.  If the pkg_no > 0, and perf_no = 0, then I look up the "first" perf_no via (the as yet UNTESTED) statement:

    I have chosen also to use a custom procedure so that the multiple pieces of data that must be assembled can be retreived in a single SQL SPROC.

    Thanks for the reply.

    Larry

     

     

    select

     

     

    @perf_no = perf_no from

    tx_perf_group_pkg

     

     

    inner join tx_perf_group on tx_perf_group_pkg.perf_group_no = tx_perf_group.

    perf_group_no

     

     

    where pkg_no =

    @pkg_no

Reply
  • $organization in reply to Patrick FitzGerald

    Thanks.  I had already started writing a custom procedure.  If the pkg_no > 0, and perf_no = 0, then I look up the "first" perf_no via (the as yet UNTESTED) statement:

    I have chosen also to use a custom procedure so that the multiple pieces of data that must be assembled can be retreived in a single SQL SPROC.

    Thanks for the reply.

    Larry

     

     

    select

     

     

    @perf_no = perf_no from

    tx_perf_group_pkg

     

     

    inner join tx_perf_group on tx_perf_group_pkg.perf_group_no = tx_perf_group.

    perf_group_no

     

     

    where pkg_no =

    @pkg_no

Children
No Data