[Rt-devel] Re: [rt-users] Searching by transaction content

[Jesse Vincent]

On Tue, Oct 18, 2005 at 02:55:36PM -0400, Jay R. Ashworth wrote:
> On Tue, Oct 18, 2005 at 02:28:24PM -0400, Jesse Vincent wrote:
> > > > Click on the dropdown whose first value is "Subject" on the search page.
> > > 
> > > That does not appear to search the *attachment content* (ie: the body
> > > text of the transactions), which is what I need.
> > 
> > It should be. Can you send the SQL queries RT is generating? Also, please try to reply to the list, so that others can have the benefit of your questions as well.
> 
> Sorry.  For some reason, my Reply-to-list blew it.
> 
> The pertinent items in the log appear to be:
> 
> 2005-10-18 18:49:50 LOG:  statement:
>              SELECT count(main.id) FROM Tickets main WHERE ((main.EffectiveId = > main.id)) AND ((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ((ma > in.Subject ILIKE '%$3%')) > 


Did you click on the select with "Subject" as its first item and, say,
pick "content"?