• Replies 31 replies
  • Subscribers 350 subscribers
  • Views 1268 views
  • Users 0 members are here
Related

Learning SQL

Melanie Boma
$organization

Hello!

I'm new to this forum as my position changed within the last year from Box Office Manager to a more IT related field of Tessitura Database Manager.  I've been learning a great deal through Tessitura training courses offered and the assistance of Tessitura support, however I hit a road block when it comes to anything requiring SQL knowledge which pops up very frequently.  Since I didn't come from an IT background, I'm lost when it comes to this and it gets tough when I keep having to go to Consulting and present a charge to Administration to get a task completed.  Do any of you have advice on how to gain basic SQL knowledge to do tasks in Tessitura.  And if there are any of you who were in this same position, how did you go about learning and moving forward?

Thank you so much,

Melanie

Parents
  • $organization

    I'm by far no SQL master but here are my favorite things with regard to keeping the box office functioning.  I learned these over the last 16 years via help tickets or peers.  You may already know them but here goes.

    *  To find the ticket element IDs for print at home designs. ???? = ticket design no

    select d.design_no, d.description, f.ele_sl_no, f.description, f.mask
    from t_design d, tx_design_element f
    where d.design_no = f.design_no
    and d.design_no = ????

    *  To unlock seats locked (in lavender) on seat maps.   ???? = locked by no

    -----You will first need to get the "locked by" number from the
    ---"database seat no" then run (replace ???? with locked by number)...

    use impresario

    tp_cleanup_connection ????

    *  To unlock ticket orders. ???? = order no

    ---- first, see if the mir lock no on the order is a number other than zero

    select * from t_order where order_no = ????

    ---- If the mir is other than zero then...

    begin tran
    update t_order
    set mir_lock = 0
    from t_order
    where mir_lock = (whatever the mir # is) and order_no = ????
    commit tran

    -- if things don't look right type:

    rollback tran

    There are many others but these are the ones I use often in the ticketing sphere.  

    Heather

Reply
  • $organization

    I'm by far no SQL master but here are my favorite things with regard to keeping the box office functioning.  I learned these over the last 16 years via help tickets or peers.  You may already know them but here goes.

    *  To find the ticket element IDs for print at home designs. ???? = ticket design no

    select d.design_no, d.description, f.ele_sl_no, f.description, f.mask
    from t_design d, tx_design_element f
    where d.design_no = f.design_no
    and d.design_no = ????

    *  To unlock seats locked (in lavender) on seat maps.   ???? = locked by no

    -----You will first need to get the "locked by" number from the
    ---"database seat no" then run (replace ???? with locked by number)...

    use impresario

    tp_cleanup_connection ????

    *  To unlock ticket orders. ???? = order no

    ---- first, see if the mir lock no on the order is a number other than zero

    select * from t_order where order_no = ????

    ---- If the mir is other than zero then...

    begin tran
    update t_order
    set mir_lock = 0
    from t_order
    where mir_lock = (whatever the mir # is) and order_no = ????
    commit tran

    -- if things don't look right type:

    rollback tran

    There are many others but these are the ones I use often in the ticketing sphere.  

    Heather

Children
No Data