0 Replies Latest reply on Sep 8, 2014 9:39 AM by capetownandre

    SQL -- relationship to the tech_group a JOB_Ticket belongs to

    capetownandre

      when looking at the ticket in the front end I see  Values in the detail pain

       

      where/ how is this value held, do I have to Navigate the problem types

       

      I am using the  below sql at the moment but does not always work correctly.

      select tg.NAME as TechGroupName from from job_ticket jt

             inner  join status_type  st on

             jt.STATUS_TYPE_ID  = st.STATUS_TYPE_ID

             inner join whd.tech wt on

             jt.ORIGINAL_TECH_ID = wt.client_id

             inner join tech_group tg on

              wt.Supervisor_ID = tg.MANAGER_ID