Changeset 8753 for trunk/src/bp-groups/bp-groups-classes.php

Timestamp:

08/03/2014 08:51:44 PM (12 years ago)

Author:

djpaul

Message:

Core: adjust the SQL generated by BP_User_Query's search_wildcard parameter for better Suggestions API search results.

Introduced in r8675, the search_wildcard parameter controls where BuddyPress places MySQL wildcard characters around the search term (when it's set).

This change adjusts how the wildcard SQL is constructed; in addition to the wildcard, we now also check for matches that have a single space character at the opposite end of the string (from where the wildcard is). This allows searching data that looks like (for example) a surname in a combined first name/surname field.
e.g. if a displayname is "Paul Gibbs", you can search for "Gi", and with search_wildcard=right, the SQL generated will be LIKE 'Gi%' OR LIKE '% Gi%'.

See #3278

File:

• trunk/src/bp-groups/bp-groups-classes.php (modified) (1 diff)

trunk/src/bp-groups/bp-groups-classes.php

@@ -4388 +4388 @@
             'per_page'        => $this->args['limit'],
             'search_terms'    => $this->args['term'],
+            'search_wildcard' => 'right',
         );