AnsweredAssumed Answered

ExecuteSql - Can this be done with this type of query

Question asked by xxx202xxx on Aug 9, 2017
Latest reply on Aug 9, 2017 by 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 )

Outcomes