[rt-users] Searching Custom Fields

[Chris Valdez]

Here is the query that was generated:

SELECT DISTINCT main.* FROM ((Tickets main LEFT JOIN ObjectCustomFieldValues
ObjectCustomFieldValues_1 ON ((Obje
ctCustomFieldValues_1.ObjectType = 'RT::Ticket')) AND(
(ObjectCustomFieldValues_1.Disabled = '0')) AND(
ObjectCustomFieldValues_1.ObjectId = main.id <http://main.id>)
) JOIN CustomFields CustomFields_2 ON ( CustomFields_2.id =
ObjectCustomFieldValues_1.CustomField) AND( (CustomFields_2.Name =
'Product'))) WHERE
((main.EffectiveId = main.id <http://main.id>)) AND ((main.Status !=
'deleted')) AND ((main.Type = 'ticket')) AND
((ObjectCustomFieldValues_1.Content LIKE '%IPM%')AND
( (main.Status = 'new')OR(main.Status = 'open') ) ) ORDER BY
main.id<http://main.id>ASC LIMIT 50

Any ideas?

On 10/8/05, Todd Chapman <todd at chaka.net> wrote:
>
> On Fri, Oct 07, 2005 at 09:54:08AM -0700, Chris Valdez wrote:
> > Hi folks,
> >
> > I'm currently running RT 3.4.1, and it's working very well for me,
> except
> > that when I try to search on a custom field, it always returns 0 results
> > even when it should be returning results. Is this an issue that would be
> > resolved by upgrading to 3.4.4? Is there something to check that I may
> have
> > mis-configured?
> >
> > Thanks for any help!
> >
> > -cv
>
> Turn on the option in MySQL where it logs all the SQL it runs
> and then figure out what query was really generated.
>
> It might also help to send us the query...
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20051010/c229adbf/attachment.htm>