Updating Ticket History

Depending on how your ticket history is set up, you may be able to distinguish between subscription tickets (‘S’ in our system) and single, individual tickets (‘I’). It’s recorded as price_type in t_tck_hist.

Lucie

I hope this is the correct forum to post this question. We have just tried pulling an extraction for multiple past performances, and instead of coming up with the number of single ticket buyers, it is giving us the total subscribers for that season. I'm using the criteria "Ticketing Performance Name," which, until now, has always provided us with the results we wanted.

This is a new problem, I'm not sure what we did to cause this. Does anyone have any ideas? Might it have anything to do with how our scheduled jobs are set up to collect history? Any way to sort this out?

Any help would be appreciated.

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!

Depending on how your ticket history is set up, you may be able to distinguish between subscription tickets (‘S’ in our system) and single, individual tickets (‘I’). It’s recorded as price_type in t_tck_hist.

Lucie

I hope this is the correct forum to post this question. We have just tried pulling an extraction for multiple past performances, and instead of coming up with the number of single ticket buyers, it is giving us the total subscribers for that season. I'm using the criteria "Ticketing Performance Name," which, until now, has always provided us with the results we wanted.

This is a new problem, I'm not sure what we did to cause this. Does anyone have any ideas? Might it have anything to do with how our scheduled jobs are set up to collect history? Any way to sort this out?

Any help would be appreciated.

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!