:role_ids => intersects_with {user.role_ids} generates this (incorrect) query
SELECT * FROM "screening_projects" WHERE (("screening_projects"."id" IN (3,4,5)) OR (1=1))
:roles => intersects_with {user.roles} generates this nearly correct query ( I don't know wehre that or 1=1 is coming from, and it's making the role_id requirement useless)
SELECT * FROM (SELECT DISTINCT ON ("screening_projects".id) "screening_projects".id, screening_projects.display_order AS alias_0 FROM "screening_projects" LEFT OUTER JOIN "screening_project_roles" ON ("screening_projects"."id" = "screening_project_roles"."screening_project_id") LEFT OUTER JOIN "roles" ON ("roles"."id" = "screening_project_roles"."role_id") WHERE (("roles"."id" IN (3,4,5)) OR (1=1)) ) AS id_list ORDER BY id_list.alias_0 LIMIT 1
Is this a bug, or do I misunderstand what is meant by the :role_ids => intersects_with {user.role_ids} statement?
Brad