Filter out items to show them based on User Permissions

Hello
We have a helpline for farmers. When farmer calls we open issues and then assign to the respective government officials. These government officials belong to a district, village and certain govt officials belong to only one department.

Ex:
Distrct collector of VIK (Srini) should only see all cases from district Vikarabad
Village Officer of Doma village should only see all cases from his village Doma
District Agriculture officer of Vikarabad, should see all cases of district vikarabad, that belong to Agri department.
Village Revenue officer of Doma village(Anuradha) should only see Agriculture cases of her village Doma (not other dept cases , nor other village cases)

Here is the design i am about to use…

  1. Create District, Village, Department DocTypes. And add various districts, villages, and departments in the docTypes respectively.
  2. Customize Issue docType to have links to District, Village, Department DocTypes.
  3. Create roles of “Distrct collector”, "Village Officer ", “District Agriculture officer”, “Village Revenue officer”.
  4. For “Distrct collector” role, go to “Role Permissions Manager” and click “Apply User Permissions”. In “Select Document Types” select “District” docType.
  5. For “Village Revenue officer” go to “Role Permissions Manager” and click “Apply User Permissions”. In “Select Document Types” select “Village”, “Department” docTypes.
  6. Similarly to other roles.
  7. Create the user Anuradha (Doma village revenue officer). And in “user permission”, add for docType Issue, allow value “doma”, and add another entry. for allow “revenue”
  8. Now in user permission. Create the user Srini (vikarabad district collector). And in “user permission”, add Srini, for docType Issue, allow value “Vikarabad”.
  9. Similarly for other users.

Please let me know if this is is right design, and if it would work.

This should work, however you only know when you try it out practically :slight_smile:

Thank you . Will try it out.