I’ve been following the SVN repo for some time now and a few weeks ago a
user of mine reported she was unable to search data in a custom field.
Indeed, (global) customfield searching is completely broken (I just svn
update’d and it’s still broken). The attached code.txt returns no rows,
though I guarantee there are thousands of matches. The resulting MySQL
query is attached as well.
It’s looking like the (ObjectCustomFields_1.ObjectId = main.Queue) is
problematic for global custom fields as the ObjectId is 0 in this case.
Indeed, if I search for data in a customfield that’s attached to a
specific queue, it works well.
query.txt (732 Bytes)
code.txt (195 Bytes)