[Rt-devel] "Updated By" search.
jesse at bestpractical.com
Mon Sep 11 06:28:11 EDT 2006
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.
> List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
More information about the Rt-devel