While working on mobile application we need to check if the user is in Manager group for a particular module. Using SQL we are able to check this condition, but can we accomplish the same using ORM? Please assist.
Following is my sql query which is listing the users who are Managers for 'Point of sale' module: Can we write an equivalent using ORM?
select login, usr.id as user_id, grp.id group_id, grp.name, cat.name
from res_users usr, res_groups_users_rel rel, res_groups grp, ir_module_category cat
where usr.id = rel.uid
and rel.gid = grp.id
and grp.category_id = cat.id
and cat.name = 'Point of Sale'
and grp.name = 'Manager';