[Rt-devel] "Updated By" search.

[Jesse Vincent]

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
> 

--