Identifying a constituent with ticket exchanges (seats)

Thanks Everyone.

Mark,

Thanks for the table t_transaction. I believe the thing I will to check if they are under in one transaction.. then snail down on the t_order_seat_hist to find out any transactions with return, refund, add back with the new seat changes.

But some people here also mentioned there are some issue with t_order_seat_hist table. However, let’s find out.

Thanks again,

-Harry

The tables you are looking at will only tell you that the seats were returned but not if that was part of an exchange or just a return+refund.

The table that may help is t_transaction as that will show a Ticket Change transaction type if the tickets werre exchanged for other tickets in the same transaction. Again this depends how exchanges are processed.

You should be able to link that to order seat history with order numebr and perf number but will also need to use event date to match around (guessing wont be an exact match but shoudl be within seconds/minutes) the transaction date

Mark

Hello,

I am doing a report on constituent with ticket exchanges. My question is by looking at some of the SQL tables such as t_order_seat_hist, t_order, t_sli_status. How can I identify that constituent having some ticket exchange transaction in that constituent? 

in fact, can I look at the order_no, sli_status for exchangeable??

Thanks,

-Harry

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!

Thanks Everyone.

Mark,

Thanks for the table t_transaction. I believe the thing I will to check if they are under in one transaction.. then snail down on the t_order_seat_hist to find out any transactions with return, refund, add back with the new seat changes.

But some people here also mentioned there are some issue with t_order_seat_hist table. However, let’s find out.

Thanks again,

-Harry

The tables you are looking at will only tell you that the seats were returned but not if that was part of an exchange or just a return+refund.

The table that may help is t_transaction as that will show a Ticket Change transaction type if the tickets werre exchanged for other tickets in the same transaction. Again this depends how exchanges are processed.

You should be able to link that to order seat history with order numebr and perf number but will also need to use event date to match around (guessing wont be an exact match but shoudl be within seconds/minutes) the transaction date

Mark

Hello,

I am doing a report on constituent with ticket exchanges. My question is by looking at some of the SQL tables such as t_order_seat_hist, t_order, t_sli_status. How can I identify that constituent having some ticket exchange transaction in that constituent? 

in fact, can I look at the order_no, sli_status for exchangeable??

Thanks,

-Harry

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!