CODEWITHSUNDEEP
ruby-on-railsruby-on-rails-3
user479959
user479959

Reputation: 507

Rails - Understanding how to Query An Objectin Rails 3

if I have the following:

@projects = Permission.where(["user_id >= ?", 21])

Results In:

[#<Permission id: 59, project_id: 13, user_id: 21>, #<Permission id: 59, project_id: 13, user_id: 21>]

I then what to use those project_id 's to QUERY as follows:

AuditLog.where({ :project_id => @projects }).limit(10)

But this errors?

NoMethodError: undefined method `project_id' for [#<Permission id: 59, project_id: 13, user_id: 21>]:ActiveRecord::Relation

Ideas? thank you

Upvotes: 0

Views: 46

Answers (1)

Jaime Bellmyer
Jaime Bellmyer

Reputation: 23307

To start, let's clean up your first query:

@permissions = Permission.where(['user_id >= ?', 21])

This is less misleading about what @permissions is actually storing. Next, remember that it's an array, and what you're saying in the next query is "where project_id is a list of ruby permission objects", and that doesn't make a valid query.

You can get the info you want, though. First, use ruby's array.map method to walk through all permissions and gather their project_id's:

@project_ids = @permissions.map(&:project_id)

Now you can tell the database to grab all audit logs where the project_id is in the list:

@audit_logs = AuditLog.where(['project_id in (?)', @project_ids])

That should give you what you need. Let me know if you have any questions.

Upvotes: 1

Related Questions