Here is the query that was generated:<br>
<br>
SELECT DISTINCT main.* FROM ((Tickets main LEFT JOIN ObjectCustomFieldValues ObjectCustomFieldValues_1 ON ((Obje<br>
ctCustomFieldValues_1.ObjectType = 'RT::Ticket')) AND(
(ObjectCustomFieldValues_1.Disabled = '0')) AND(
ObjectCustomFieldValues_1.ObjectId = <a href="http://main.id">main.id</a>)<br>
) JOIN CustomFields CustomFields_2 ON ( CustomFields_2.id =
ObjectCustomFieldValues_1.CustomField) AND( (CustomFields_2.Name =
'Product'))) WHERE <br>
((main.EffectiveId = <a href="http://main.id">main.id</a>)) AND ((main.Status != 'deleted')) AND
((main.Type = 'ticket')) AND ((ObjectCustomFieldValues_1.Content LIKE
'%IPM%')AND <br>
( (main.Status = 'new')OR(main.Status = 'open') ) ) ORDER BY <a href="http://main.id">main.id</a> ASC LIMIT 50<br>
<br>
Any ideas?<br><br><div><span class="gmail_quote">On 10/8/05, <b class="gmail_sendername">Todd Chapman</b> <<a href="mailto:todd@chaka.net">todd@chaka.net</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On Fri, Oct 07, 2005 at 09:54:08AM -0700, Chris Valdez wrote:<br>> Hi folks,<br>><br>> I'm currently running RT 3.4.1, and it's working very well for me, except<br>> that when I try to search on a custom field, it always returns 0 results
<br>> even when it should be returning results. Is this an issue that would be<br>> resolved by upgrading to 3.4.4? Is there something to check that I may have<br>> mis-configured?<br>><br>> Thanks for any help!
<br>><br>> -cv<br><br>Turn on the option in MySQL where it logs all the SQL it runs<br>and then figure out what query was really generated.<br><br>It might also help to send us the query...<br></blockquote></div><br>