Searching by transaction content

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.

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

So I found, yesterday, that I knew I had noted something in a ticket
transaction that I needed to find again… and that search apparently
does not search transaction attachment content.

Luckily I had PHPPgAdmin on that box, and I managed to remember how to
specify a LIKE clause to search Attachments->Content.

But should it really be that hard? Or am I missing something?

Cheers,
– jra
Jay R. Ashworth jra@baylink.com
Designer Baylink RFC 2100
Ashworth & Associates The Things I Think '87 e24
St Petersburg FL USA http://baylink.pitas.com +1 727 647 1274

"NPR has a lot in common with Nascar... we both turn to the left."
	- Peter Sagal, on Wait Wait, Don't Tell Me!

So I found, yesterday, that I knew I had noted something in a ticket
transaction that I needed to find again… and that search apparently
does not search transaction attachment content.

Click on the dropdown whose first value is “Subject” on the search page.