[Rt-devel] "Updated By" search.
matthew at sorbs.net
Sun Sep 10 22:42:40 EDT 2006
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.
More information about the Rt-devel