Select instance having an attribute included in an array

Question

I'm using Public Activity to create a feed, and I'd like to filter the activities. I don't want to show to the current_user its own activities so I have:

@activities = PublicActivity::Activity.where.not(owner_id: current_user.id)

And this works well. I want to add a second filter, which is to only display activities that belong to the users followed by current_user.

I can get all the followed users using:

@users = current_user.following

My question is: how can I filter the activities by checking if owner_id is the id of a user included in @users ?

EDIT:

activities table:

create_table "activities", force: :cascade do |t|
    t.integer  "trackable_id"
    t.string   "trackable_type"
    t.integer  "owner_id"
    t.string   "owner_type"
    t.string   "key"
    t.text     "parameters"
    t.integer  "recipient_id"
    t.string   "recipient_type"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.boolean  "read",           default: false
    t.string   "origin"
  end

Anthony E · Accepted Answer · 2016-05-18 08:24:58Z

1

Try the following:

Activity.joins(:owner).where.not(
           users: {id: current_user.id}
       ).joins(owner: :followings).where(
           followings: { follower_id: current_user.id }
       )

This translates to all activities DO NOT belonging to the current_user but DO belong to a user followed by current_user.

You may need to replace values were appropriate.

edited May 18, 2016 at 8:24

answered May 18, 2016 at 7:35

Anthony E

11.3k2 gold badges28 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Graham Slick Over a year ago

Thanks for your answer. Howerver, I get this error: Association named 'users' was not found on PublicActivity::Activity This might be due to the fact that by default, the activities table as a owner_id attribute but not a user. Should I add a reference to the user table in the activity table ? I've edited my question with the table

Anthony E Over a year ago

No need to change the reference when a simple change to query will do: Activity.joins(:owners). See my update

Graham Slick Over a year ago

Same error: Association named 'owners' was not found on PublicActivity::Activity

Anthony E Over a year ago

Then do :owner instead of owners

Anthony E Over a year ago

Whatever the relation is named goes in the joins

|

Collectives™ on Stack Overflow

Select instance having an attribute included in an array

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related