"Updated By" search

RT Developers
1

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

2

Hey all,

RT 3.4.x

3.4.what? I recall this actually getting implemented somewhere around
3.4.4 or 3.4.5.

3

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 ??
Roy

Jesse Vincent wrote:

4

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

5

If its only that simple :�) … BTW where about in Tickets_Overlay.pm
Thanks;
Roy

Jesse Vincent wrote: