Does anyone know the values that need to be used to return all tickets associated with user session? The docs I have show that only the session id is required but it seems that the iSeasonNo, iProdSeasonNo and the iPerfNo also need values. I'm wondering how I can query all of those three values without having to be specific about each (some method parameters allow "-1" to be used).
Well...if I had downloaded the newest doc for WebAPI V.9 I would have seen that it's 0.
However, now I'm not getting any results. Just an empty data set. I know that the user associated with the session has a ticket history because I'm looking at in Tessitura. However the API returns an empty dataset. Is there something I'm missing?
No one?
Are you passing 0 for the parameters
1. iSeasonNo
2. iProductionSeasonNo
3. iPerfNo
If you have access to Sql Server Management Studio, Do you get anything back from this query?
SELECT
*
FROM
LV_TKT_HIST_REPORT
WHERE
customer_no = ####
Replace #### with the customer number you are testing with.
Marty
For tickets, call Ticket Omaha at 402.345.0606
From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Gordon Taylor Sent: Wednesday, February 17, 2010 1:25 PM To: Martin A. Jones Subject: Re: [Tessitura Web Forum] GetTicketHistory
From: Gordon Taylor <bounce-gordontaylor1516@tessituranetwork.com> Sent: 2/12/2010 1:27:42 PM
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!
Thanks everyone!!
As it turns out, we have a custom defined ticket history table. The original table being used by the API is empty which explains the empty dataset.
Kevin, could you tell me which view GetSubscriptionHistory pulls from? We also have a custom table for subs history and I need to modify the view to pull from the correct datasource.
LF_SUB_HIST_REPORT
Kevin Sheehan
Documentation & Learning Resources Specialist
Tessitura Network
1 888 643 5778 ext 329 Office
ksheehan@tessituranetwork.com
From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Gordon Taylor Sent: Friday, February 19, 2010 1:11 PM To: Kevin Sheehan Subject: Re: [Tessitura Web Forum] RE: GetTicketHistory
From: Gordon Taylor <bounce-gordontaylor1516@tessituranetwork.com> Sent: 2/17/2010 4:15:39 PM
No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.435 / Virus Database: 271.1.1/2678 - Release Date: 02/19/10 07:34:00
Thank you ver much!!