Hi
I would like to know how to set a column in a query that shows the
time between the ticket was created an resolved.
Example:
Created : 20090301
Resolved : 20090310
Between : 9 days (hour, etc)
I’ve tried query builder in advance but can’t find some functions that
i can use like in sql.
thanks,
Atte.
Andres Altamirano
Subdirección Innovación Tecnológica
Dirección de Informática
Pontificia Universidad Católica de Chile
Campus San Joaquin. Vicuña Mackena 4860
Fono: +56 2 3547183
smime.p7s (3.13 KB)
It’s something you should name yourself and hack in ColumnMap, see
lib/RT/Date.pm for dates API. It’s should be pretty easy to implement.On Wed, Apr 29, 2009 at 12:39 AM, Andres Altamirano aaltamirano@uc.cl wrote:
Hi
I would like to know how to set a column in a query that shows the
time between the ticket was created an resolved.
Example:
Created : 20090301
Resolved : 20090310
Between : 9 days (hour, etc)
I’ve tried query builder in advance but can’t find some functions that
i can use like in sql.
thanks,
–
Atte.
Andres Altamirano
Subdirección Innovación Tecnológica
Dirección de Informática
Pontificia Universidad Católica de Chile
Campus San Joaquin. Vicuña Mackena 4860
Fono: +56 2 3547183
The rt-users Archives
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com
Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Best regards, Ruslan.