• Replies 3 replies
  • Subscribers 246 subscribers
  • Views 69 views
  • Users 0 members are here
Related

Best Available seat question

Amy Aldrich
$organization

I am going to try to explain this as best as possible since I am not a technical mastermind. 

We are in the process of developing a new web site. We have a seat map for one of our venues that has seating built as tables, with 5 seats at a table. So when you see the seat listed its (Section aka.. table) 101, (Row) C, (Seats) 1-3.

Our web developers tell me that when they query the seats (this is for best available seating)  they don't see the "Sec" (table) number. They just see the ID of the section description from TR_Section, which is different from the table label or name. 

How can they see this table number? Anyone have any ideas or suggestions?They see the row and the seat numbers, but not the correct "section (table)" not to be confused with the labels on the sections tab in the facility manager seat map.

I apologize if this doesn't make sense.

Thanks,

Amy

 

 

Parents
  • Former Member
    Former Member $organization

    The Section assigned to a seat in Facility Manager is stored in the T_SEAT table.  The Section column in T_SEAT is a numeric value that joins to the ID column in the TR_SECTION table.

     

    Bob

     

    From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Gloria Ormsby
    Sent: Friday, June 03, 2011 9:11 AM
    To: Robert Bell
    Subject: RE: [Tessitura Web Forum] Best Available seat question

     

    I believe the sections are pulled from zones.

     

    From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Amy Aldrich
    Sent: Thursday, June 02, 2011 4:52 PM
    To: Gloria Ormsby
    Subject: [Tessitura Web Forum] Best Available seat question

     

    I am going to try to explain this as best as possible since I am not a technical mastermind. 

    We are in the process of developing a new web site. We have a seat map for one of our venues that has seating built as tables, with 5 seats at a table. So when you see the seat listed its (Section aka.. table) 101, (Row) C, (Seats) 1-3.

    Our web developers tell me that when they query the seats (this is for best available seating)  they don't see the "Sec" (table) number. They just see the ID of the section description from TR_Section, which is different from the table label or name. 

    How can they see this table number? Anyone have any ideas or suggestions?They see the row and the seat numbers, but not the correct "section (table)" not to be confused with the labels on the sections tab in the facility manager seat map.

    I apologize if this doesn't make sense.

    Thanks,

    Amy

     

     




    You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web 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!




    You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web 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!

Reply
  • Former Member
    Former Member $organization

    The Section assigned to a seat in Facility Manager is stored in the T_SEAT table.  The Section column in T_SEAT is a numeric value that joins to the ID column in the TR_SECTION table.

     

    Bob

     

    From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Gloria Ormsby
    Sent: Friday, June 03, 2011 9:11 AM
    To: Robert Bell
    Subject: RE: [Tessitura Web Forum] Best Available seat question

     

    I believe the sections are pulled from zones.

     

    From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Amy Aldrich
    Sent: Thursday, June 02, 2011 4:52 PM
    To: Gloria Ormsby
    Subject: [Tessitura Web Forum] Best Available seat question

     

    I am going to try to explain this as best as possible since I am not a technical mastermind. 

    We are in the process of developing a new web site. We have a seat map for one of our venues that has seating built as tables, with 5 seats at a table. So when you see the seat listed its (Section aka.. table) 101, (Row) C, (Seats) 1-3.

    Our web developers tell me that when they query the seats (this is for best available seating)  they don't see the "Sec" (table) number. They just see the ID of the section description from TR_Section, which is different from the table label or name. 

    How can they see this table number? Anyone have any ideas or suggestions?They see the row and the seat numbers, but not the correct "section (table)" not to be confused with the labels on the sections tab in the facility manager seat map.

    I apologize if this doesn't make sense.

    Thanks,

    Amy

     

     




    You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web 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!




    You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web 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!

Children
No Data