[Rt-devel] "Updated By" search.

[Jesse Vincent]

On Mon, Sep 11, 2006 at 11:32:09AM +0100, Roy El-Hames wrote:
> Jesse;
> Sorry to interfere (but I need this patch ). Unless I am missing 
> something completely obvious, there is no search criteria for UpdatedBy, 
> there is LastUpdatedBy which is something different ??

Apologies, we did "Updated", not UpdatedBy. However, that does most of
the "hard bits" in Tickets_Overlay.pm

> Roy
> 
> Jesse Vincent wrote:
> >
> >On Mon, Sep 11, 2006 at 12:42:40PM +1000, Matthew Sullivan wrote:
> >  
> >>Hey all,
> >>
> >>RT 3.4.x
> >>    
> >
> >3.4.what? I recall this actually getting implemented somewhere around
> >3.4.4 or 3.4.5.
> >
> >
> >  
> >>Trying to patch in a search for 'Updated By'
> >>
> >>SQL to return tickets "Updated By' seems to be as simple as:
> >>
> >>SELECT DISTINCT t.id
> >>FROM users u, tickets t, transactions tr
> >>WHERE u.name = ?
> >>   AND t.id = tr.objectid
> >>   AND tr.objecttype = 'RT::Ticket'
> >>   AND tr.creator = u.id
> >>   AND t.disabled = 0;
> >>
> >>Adding to the interface is simple as updating Search/Elements/PickBasics 
> >>however, I can't seem to work out how to attach the SQL to the field...
> >>
> >>Pointers to where would be appreciated.
> >>
> >>Thanks,
> >>
> >>Mat
> >>_______________________________________________
> >>List info: 
> >>http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
> >>
> >>    
> >
> >  
> 

--