A patron called stating they were confused by our SYOS map on TNEW when selecting a seat in one of our boxes. For example, when hovering over the seat it displays "Row 22 Seat 1", when they are used to referring to it as "Box 22 Seat 1". My question is, is it possible to change the value in T_SEAT, updating seat_row from '22' to 'Box 22'? Would this work and not cause damage to anything?
Thanks,
Steve
Hopefully someone else will confirm this, but seat row appears in quite a few places (TX_PERF_SEAT, T_SPECIAL_REQ, TX_COMPOSITE_SEAT among others). I don't see any triggers that would make me think that changing T_SEAT would flow downhill into the other tables.
I don't know a ton about ticket design, but for tickets that have already been sold, you might be better off trying to mask the row description in the design itself (or in a report dataset if that's more appropriate.)
I believe in the database when you hover over a seat in the seat map view , it displays three parameters like: Grandstand EE 2. In our configuration , the second parameter could represent row or table #. When hovering over a seat in SYOS for that venue , it displays “Table/Row EE Seat 2”. We haven’t changed anything in the database …
Sabina
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Steve Lang Sent: Tuesday, January 14, 2014 9:33 AM To: Sabina Spilkin Subject: [Tessitura Technical Forum] Changing seat_row value
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!