2 Replies Latest reply on Aug 9, 2017 5:39 PM by xxx202xxx

    ExecuteSql - Can this be done with this type of query

    xxx202xxx

      I do not know how to do the following with the given script.  I am trying to only list values that are > 1 but no clear understanding as to how.  This script ask the question, How many times does a Ticket's status gets changed to Resolved and places that number in a field. 

       

      ExecuteSQL ("

      SELECT (COUNT  (Status))
      FROM Time_Management_Incident_Log
      WHERE Status=? AND TicketID_fk=?
      GROUP BY TicketID_fk"

      ;" -  "; ""; "Resolved"; Service_Management::Ticket_ID )