RT automatically stores dates and times into tickets when they are created, opened and closed.
I notice that you want a relative value (e.g. "40 minutes ago"), which means that that value is only meaningful for a very short time, so perhaps you're wanting to place it in an outgoing email or something. Can you tell us more about how you want to use this? I suspect so far that a custom field isn't necessary. On 31/07/2014 1:29 am, "AJ" <[email protected]> wrote: > Hi, > > I have made a "datetime" CustomField. Whenever a ticket is changed from > open > to resolve the date and time will be inserted into the custom field. > > However I want it to display the time elapsed e.g. 40 minutes ago etc. > > This is the code I am using in location > /html/Callbacks/MyRT/Elements/RT__Ticket/ColumnMap > > <%init> > $COLUMN_MAP->{DifferenceReopenedTime} = { > title => 'Reopened', # loc > attribute => 'Reopened', > value => sub { > my $CFValue = $Ticket->FirstCustomFieldValue('13') > my $now = RT::Date->new($RT::SystemUser); > $now->SetToNow(); > > > return $CFValue->AgeAsString(); > } > }; > </%init> > <%args> > $COLUMN_MAP > </%args> > > Can anyone help > > > > -- > View this message in context: > http://requesttracker.8502.n7.nabble.com/Add-Time-difference-in-search-result-tp58100.html > Sent from the Request Tracker - User mailing list archive at Nabble.com. > -- > RT Training - Boston, September 9-10 > http://bestpractical.com/training >
-- RT Training - Boston, September 9-10 http://bestpractical.com/training
