[rt-users] search query returning unexpected results

[Chanel Wheeler]

Hi all,

This is the search query I have (built via the Query Builder):
Owner = 'cwheeler' AND (  Status = 'new' OR Status = 'open' ) AND Queue = 'YLN' AND 'CF.{YLN Topic}' != 'Student Import System'

The search results *include* the tickets tagged with Student Import System. If I change the 'not equal' to 'equal' it limits the search as you'd expect it to. Same thing happens with LIKE vs NOT LIKE. This is looking a lot like a bug but I'm wondering if manipulating custom fields in this way just isn't allowed.  I'm on 4.2.6.

Any ideas?

Thanks,
chanel


--
Chanel Wheeler
Programmer/Analyst
Yavapai Library Network
1120 Commerce Dr.
Prescott, AZ  86305

Phone: (928) 442-5741
chanel.wheeler at yavapai.us<mailto:chanel.wheeler at yavapai.us>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140826/6eafbf3f/attachment.htm>