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?
Hi Gordon,
I’m currently at work on revising the API document and this method actually just came up in one of the reviews. The method retrieves data from the local view LF_TKT_HIST_REPORT, and that view must be configured to represent data from ticket history table. Everyone customizes their ticket history a little, so those customizations must also be made to LF_TKT_HIST_REPORT. I suspect the view is not being updated with data from your ticket history. If the view turns out not to be the problem, I suggest opening a help ticket.
Good luck!
Kevin Sheehan
Documentation & Learning Resources Specialist
Tessitura Network
1 888 643 5778 ext 329 Office
ksheehan@tessituranetwork.com
Hi, Gordon,
I just ran a test. Passing in "0" for iSeasonNo, iProdSeasonNo, and iPerfNo (empty string for all other fields) worked for me. You might want to submit a support ticket.
-Morgan
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
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!!