Finding when a seat has been locked

Chris

If it is a different approach than the one that Mark sent, I would love to see it, to find out if it will work better for us. My email address is fmargueirat@national.ballet.ca.

Thank you.

Fernando Margueirat
Business Analyst
The National Ballet of Canada
470 Queens Quay West
Toronto, Ontario
M5V 3K4
P: 416 345 9686 x453
F: 416 345 8323

I wrote a custom report ages ago that looks for these "orphan" orders that have an row in t_web_order but no corresponding record in t_order.

If interested, drop me an e-mail offline and I'm happy to share.

Sometimes we find that some "orphan" web transactions leave seats locked for several hours and even days. We are trying to find a way to detect these locked seats so we can release them immediately. Although it is easy to find the seats that are locked, we don't know how to find if they are being held by current web purchases. Does anyone knows if there is a way to find when a seat has been locked? That way we can identify the seats that have been locked for some time, e.g .1 hour.

Thanks

Business Analyst
The National Ballet of Canada
470 Queens Quay West
Toronto, Ontario
M5V 3K4
P: 416 345 9686 x453
F: 416 345 8323

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!

Chris

If it is a different approach than the one that Mark sent, I would love to see it, to find out if it will work better for us. My email address is fmargueirat@national.ballet.ca.

Thank you.

Fernando Margueirat
Business Analyst
The National Ballet of Canada
470 Queens Quay West
Toronto, Ontario
M5V 3K4
P: 416 345 9686 x453
F: 416 345 8323

I wrote a custom report ages ago that looks for these "orphan" orders that have an row in t_web_order but no corresponding record in t_order.

If interested, drop me an e-mail offline and I'm happy to share.

Sometimes we find that some "orphan" web transactions leave seats locked for several hours and even days. We are trying to find a way to detect these locked seats so we can release them immediately. Although it is easy to find the seats that are locked, we don't know how to find if they are being held by current web purchases. Does anyone knows if there is a way to find when a seat has been locked? That way we can identify the seats that have been locked for some time, e.g .1 hour.

Thanks

Business Analyst
The National Ballet of Canada
470 Queens Quay West
Toronto, Ontario
M5V 3K4
P: 416 345 9686 x453
F: 416 345 8323

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!