[buddypress-trac] [BuddyPress] #5119: Group Meta Query - allow more than one meta_key

[buddypress-trac]

#5119: Group Meta Query - allow more than one meta_key
-----------------------------------+---------------------------
 Reporter:  imath                  |       Owner:  boonebgorges
     Type:  enhancement            |      Status:  closed
 Priority:  normal                 |   Milestone:  1.8.1
Component:  Groups                 |     Version:  1.8
 Severity:  normal                 |  Resolution:  fixed
 Keywords:  has-patch 2nd-opinion  |
-----------------------------------+---------------------------

Comment (by boonebgorges):

 In [changeset:"7323"]:
 {{{
 #!CommitTicketReference repository="" revision="7323"
 Fixes groups meta_query for multiple clauses

 The 1.8 implementation of meta_query for BP_Groups_Group::get() did not
 properly handle multiple clauses, because of certain necessary
 transformations of the SQL syntax to match the peculiar syntax in the
 groups component. This changeset fixes the problem by improving the
 logic used to parse the SQL returned from the WP_Meta_Query object.

 A related included fix is that a DISTINCT keyword has been added to the
 main SELECT clause of the groups total sql statement. This ensures that
 multi-clause meta_query queries will not return duplicate values.

 Also adds an automated test for the situation described above.

 Fixes #5119

 Props imath
 }}}

--
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/5119#comment:3>
BuddyPress <http://buddypress.org/>
BuddyPress