Exclude specific user_id’s when querying for activities

[username_]

I didn’t see an exclude option for user_id just activity_id.

I do see the ability to include user_ids to be queried and that it can be an array of user_ids, most likely for the single member pages. But this is inclusive and I would like to see maybe the option to exclude some users from the main activity wall. Say user A doesn’t want to see user B’s updates anymore because they are negative… Some members seem to get on others nerves.

This option seems more important as a buddypress site grows in members say 5,000.

I'll try to look into some possible work around for now but all I can come up with are slow work around algorithms.

[slaFFik]

I see the value in this. Similar to post__in and post__not_in in WP_Query class.

What about the naming? user_id and user_id_not?

We basically need to create BP_Activity_Activity::get_not_in_operator_sql(). We already have BP_Activity_Query::get_sql_for_clause() which does support NOT IN.

See also bp_activity_get(), BP_Activity_Activity::get(), bp_has_activities().

[boonebgorges]

user_id__in and user_id__not_in seem the most consistent.

We basically need to create BP_Activity_Activity::get_not_in_operator_sql(). We already have BP_Activity_Query::get_sql_for_clause() which does support NOT IN.

It may be better - less code, more future-compatible - to translate the new parameters into BP_Activity_Query objects.

[slaFFik]

See #6645, that seems should be done before this ticket.

Also #6843 somewhat related in terms of BP_Activity_Query usage.

[boonebgorges]

If we wait for #6645, there's no way this'll make it into 2.8.

I don't see a problem with adding user_id__in etc and having them translated directly into SQL.

[imath]

​4184.patch is using the BP_Activity_Query class to generate SQL WHERE clause about including/excluding a list of user IDs. It also includes unit tests.

[imath]

In 13337:

Activity introduce 2 new parameters to BP_Activity_Activity::get()`

• The user_id__in parameter makes it possible to retrieve activities for

a list of user IDs.

• The user_id__not_in parameter makes it possible to exclude activity

posted by a list of user IDs from retrieved activities.

Props username_, slaFFik, boonebgorges

Fixes #4184