Rails 3 - Need Help To Understand How QUERY WITH WHERE IN (XXXXX)

Question

I want to create a rails request as shown below. And I would like to know how I can do it again on my own.

Pseudocode:

@usersprojects = ?? Do I have notes or just objects here? not sure?

SELECT * FROM audit_log WHERE project_id IN (@usersprojects)

In where does IN () do some, how to tell Rails to use record.id?

Thank you so much for your help in this. I want Rails!

Answer 1

Answer to

@kchau was close, but you need to display project_id from these entries, for example:

AuditLogs.find(@userprojects.map(&:project_id))

Answer 2

, @usersprojects , , :

    logs = AuditLogs.find(@userprojects)

Rails guide .