[Rt-devel] "Updated By" search.

[Roy El-Hames]

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:
>
> 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
>>
>>     
>
>