Tickets :: Comment on [#12480] Autocomplete includes all addresses for a user where any of them match

* Your Email Address
* Spam protection	Enter the letters below: .__..__ . ..__ . , \| \|[ __\| \|[__) \./ \|__\[_./\|__\|\| \ \|
Comment	> I can verify that this works fine for me. Here's the SQL statement > that appears in the DEBUG logs (searching for the string "test"): > > 2013-07-23T13:21:01-06:00 DEBUG: HORDE [turba] SQL (0.0144s) > SELECT object_id, object_type, owner_id, object_members, > object_nameprefix, object_firstname, object_middlenames, > object_lastname, object_namesuffix, object_email FROM turba_objects > WHERE (owner_id = 'slusarz' AND (object_firstname ILIKE '%test%' OR > object_lastname ILIKE '%test%' OR object_middlenames ILIKE > '%test%' OR > object_nameprefix ILIKE '%test%' OR object_namesuffix ILIKE > '%test%' > OR (object_nameprefix ILIKE '%test%' OR object_firstname ILIKE > '%test%' OR object_middlenames ILIKE '%test%' OR > object_lastname ILIKE > '%test%' OR object_namesuffix ILIKE '%test%') OR object_alias ILIKE > '%test%' OR object_yomifirstname ILIKE '%test%' OR > object_yomilastname > ILIKE '%test%' OR object_bday ILIKE '%test%' OR object_anniversary > ILIKE '%test%' OR object_spouse ILIKE '%test%' OR object_phototype > ILIKE '%test%' OR object_homestreet ILIKE '%test%' OR > object_homepob > ILIKE '%test%' OR object_homecity ILIKE '%test%' OR > object_homeprovince ILIKE '%test%' OR object_homepostalcode ILIKE > '%test%' OR object_homecountry ILIKE '%test%' OR (object_nameprefix > ILIKE '%test%' OR object_firstname ILIKE '%test%' OR > object_middlenames ILIKE '%test%' OR object_lastname ILIKE > '%test%' OR > object_namesuffix ILIKE '%test%' OR object_homestreet ILIKE > '%test%' > OR object_homecity ILIKE '%test%' OR object_homeprovince ILIKE > '%test%' OR object_homepostalcode ILIKE '%test%') OR > object_workstreet > ILIKE '%test%' OR object_workpob ILIKE '%test%' OR object_workcity > ILIKE '%test%' OR object_workprovince ILIKE '%test%' OR > object_workpostalcode ILIKE '%test%' OR object_workcountry ILIKE > '%test%' OR (object_nameprefix ILIKE '%test%' OR object_firstname > ILIKE '%test%' OR object_middlenames ILIKE '%test%' OR > object_lastname > ILIKE '%test%' OR object_namesuffix ILIKE '%test%' OR > object_homestreet ILIKE '%test%' OR object_homecity ILIKE > '%test%' OR > object_homeprovince ILIKE '%test%' OR object_homepostalcode ILIKE > '%test%' OR object_workstreet ILIKE '%test%' OR > object_workcity ILIKE > '%test%' OR object_workprovince ILIKE '%test%' OR > object_workpostalcode ILIKE '%test%') OR object_otherstreet ILIKE > '%test%' OR object_otherpob ILIKE '%test%' OR > object_othercity ILIKE > '%test%' OR object_otherprovince ILIKE '%test%' OR > object_otherpostalcode ILIKE '%test%' OR object_othercountry ILIKE > '%test%' OR (object_nameprefix ILIKE '%test%' OR object_firstname > ILIKE '%test%' OR object_middlenames ILIKE '%test%' OR > object_lastname > ILIKE '%test%' OR object_namesuffix ILIKE '%test%' OR > object_homestreet ILIKE '%test%' OR object_homecity ILIKE > '%test%' OR > object_homeprovince ILIKE '%test%' OR object_homepostalcode ILIKE > '%test%' OR object_workstreet ILIKE '%test%' OR > object_workcity ILIKE > '%test%' OR object_workprovince ILIKE '%test%' OR > object_workpostalcode ILIKE '%test%' OR object_otherstreet ILIKE > '%test%' OR object_othercity ILIKE '%test%' OR object_otherprovince > ILIKE '%test%' OR object_otherpostalcode ILIKE '%test%') OR > object_department ILIKE '%test%' OR object_manager ILIKE > '%test%' OR > object_assistant ILIKE '%test%' OR object_tz ILIKE '%test%' OR > object_email ILIKE '%test%' OR object_homephone ILIKE '%test%' OR > object_homephone2 ILIKE '%test%' OR object_homefax ILIKE > '%test%' OR > object_workphone ILIKE '%test%' OR object_workphone2 ILIKE > '%test%' OR > object_cellphone ILIKE '%test%' OR object_carphone ILIKE > '%test%' OR > object_radiophone ILIKE '%test%' OR object_companyphone > ILIKE '%test%' > OR object_assistantphone ILIKE '%test%' OR object_fax ILIKE > '%test%' > OR object_pager ILIKE '%test%' OR object_title ILIKE '%test%' OR > object_role ILIKE '%test%' OR object_company ILIKE '%test%' OR > object_logotype ILIKE '%test%' OR object_category ILIKE '%test%' OR > object_notes ILIKE '%test%' OR object_url ILIKE '%test%' OR > object_freebusyurl ILIKE '%test%' OR object_pgppublickey ILIKE > '%test%' OR object_smimepublickey ILIKE '%test%' OR > object_imaddress > ILIKE '%test%' OR object_imaddress2 ILIKE '%test%' OR > object_imaddress3 ILIKE '%test%')) [pid 7223 on line 558 of > "/disk2/src/horde/framework/Db/lib/Horde/Db/Adapter/Base.php"] >
Attachment
Watch this ticket

Saved Queries