[Rt-devel] "Updated By" search.

[Matthew Sullivan]

Hey all,

RT 3.4.x

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