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 <[email protected]> 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: [email protected] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- Best regards, Ruslan. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
