Need some creative thinking here.
I set up a handler with the StatAlertServer initiator, alert goes off based on the "Longest Hold Time" statistic in ICBM and the handler checks some info on the call and sends email alert to managers (out of the box alerts are horrible and doesn't give any usefull info like agent or Interaction ID).
The way I'm thinking of doing it is via the Query Queue step and looping thru all calls in queue checking for Eic_State = "H" and then the handler compares $Now with Eic_StateTimestamp and checks if the difference is greater than the value of sStatLowerBound which is the value that was used in ICBM to trigger the alert (value of Longest Hold Time is greater than 1:30 minutes).
My problem is that the value of sStatLowerBound (string) comes in as "1m 30.0s", if I convert this value to integer it'll get me a value of 15 - not 90, converting to DateTime value is even worse.
The question is how to convert "1m 30.0s" in string to an integer value which will equal the amount of seconds in 1:30 minutes - 90?