[rt-users] Time between created and resolved

[Ruslan Zakirov]

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 at 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
>
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at 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.