[buddypress-trac] [BuddyPress Trac] #3430: Groups Members - add Order by: Group Activity

[buddypress-trac]

#3430: Groups Members - add Order by: Group Activity
-------------------------+-----------------------------
 Reporter:  slaFFik      |       Owner:  slaFFik
     Type:  enhancement  |      Status:  new
 Priority:  normal       |   Milestone:  Future Release
Component:  Groups       |     Version:  1.5
 Severity:  normal       |  Resolution:
 Keywords:  needs-patch  |
-------------------------+-----------------------------
Changes (by boonebgorges):

 * keywords:  dev-feedback => needs-patch


Comment:

 The logic for the group ordering would look something like this:

 `SELECT DISTINCT user_id FROM wp_bp_activity WHERE component = 'groups'
 AND item_id = {$group_id} ORDER BY date_recorded DESC`

 I don't see that there's a reason to cache this in the same way we cache
 'last_activity', especially since it'd mean a separate value for every
 group in which a user has been active.

 This does seem like a reasonable request and not totally inappropriate for
 core. If anyone wants to have a shot at a patch, have a look at
 `BP_User_Query` and the logic suggested above as a starting place.

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