Hello, I am trying to make proper set to be use as a IS_IN_DB, but for building the set I need to join on 2 tables... IS_IN_DB() doesn't seems to like my set...
Here my query that works and that I try to pass as a set... I know that it is not a set but a select... But how to make a left join in a set? role1_set = db(db.auth_group.role=='role1_test').select(db.auth_user.ALL, left=[db.auth_membership.on(db.auth_user.id==db.auth_membership.user_id), db.auth_group.on(db.auth_membership.group_id==db.auth_group.id)]) Thanks. Richard
