Does anyone know what table contains the Facility id’s ?
The T_FACILITY table is not accessible via Tessitura "System Tables" but is an integral table in the Impresario database. The contents of the table are associated with a Housemap and can be viewed in Ticketing Setup > Facility Manager > Facility tab and as Tiffany noted, the contents of the table can be queried in SQL Server Management Studio but should be created and edited if necessary within Facility Manger.
Bob
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Tiffany Evans Sent: Thursday, January 8, 2015 12:29 PM To: Robert Bell Subject: RE: [Tessitura Technical Forum] where to find facility IDs
I've never seen this table in Tessitura out of the box. I've only found it by finding it in SQL Server Management Studio and writing a new query to get that data.
Tiffany
From: Lauren Kelly <bounce-laurenkelly5154@tessituranetwork.com> Sent: 1/8/2015 10:47:44 AM
Did this table move with v.12? I don't seem to have a T_facility table.
Thanks,
Lauren
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!