[Rt-devel] "Updated By" search.

[Roy El-Hames]

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

Jesse Vincent wrote:
>
> On Mon, Sep 11, 2006 at 11:32:09AM +0100, Roy El-Hames wrote:
>   
>> 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
>
>   
>> 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
>>>>
>>>>    
>>>>         
>>>  
>>>       
>
>