Dear,
I have the following query, I am performing a query through the rt api, in php as follows:
Query:
$response = $rt->search(“Status != ‘resolved’ AND Status != 'rejected’AND LastUpdated < ‘20 days ago’”,‘-Created’, ‘s’);
And as a result I get:
Array
(
[id] => ticket/1161467
[Queue] => SOP-Sistemas
[Owner] => jchamorr
[Creator] => bgr
[Subject] => Fwd: sala de ciencias políticas en dominio crisol
[Status] => stalled
[Priority] => 0
[InitialPriority] => 0
[FinalPriority] => 0
[Requestors] => bgr@uc.cl, jhernandeu@uc.cl
[Cc] =>
[AdminCc] =>
[Created] => Mar Jul 11 11:59:06 2017
[Starts] => No establecido
[Started] => Mié Jul 12 12:41:30 2017
[Due] => No establecido
[Resolved] => No establecido
[Told] => Mié Jul 26 10:35:00 2017
[LastUpdated] => Mié Jul 26 10:35:00 2017
[TimeEstimated] => 0
[TimeWorked] => 20 minutes
[TimeLeft] => 0
[CF.{Reiteracion}] =>
[CF.{Categoría}] => Operacional
[CF.{Resumen Hechos relevantes}] =>
[CF.{Servicios-Sop_Sistemas}] => Plataforma Unix
[CF.{Hecho relevante}] => No
[CF.{Subcategorias-Servicios_Sistemas}] =>
My problem is with the format of the following fields:
[TimeEstimated] => 0
[TimeWorked] => 20 minutes
[TimeLeft] => 0
How can I get these fields in numerical form and not string? , Is there any parameter I can add to the query?
And in these others how could I format the date in a format valid for php or timestamp, at the time of the query?
[Created] => Mar Jul 11 11:59:06 2017
[Starts] => No establecido
[Started] => Mié Jul 12 12:41:30 2017
[Due] => No establecido
[Resolved] => No establecido
[Told] => Mié Jul 26 10:35:00 2017
[LastUpdated] => Mié Jul 26 10:35:00 2017
Stay tuned to your comments
regards