How to modify SQL query using Rails relationships?

Question

Ruby on Rails

This is automatically generated
SELECT "users".* FROM "users" INNER JOIN "workspace_roots" ON "users"."id" = "workspace_roots"."user_id" WHERE "workspace_roots"."root_id" = ? [["root_id", 2]]
It is necessary to put another value instead of 2, despite the fact that this value is taken from another object accessible by reference.

Answer 1

User.joins(:workspace_roots).where(workspace_roots: { root_id: 5 })

5 replace with the desired ID