We require a hierarchical data filtering structure for Frappe CRM modules (Lead, Deal, Task, Note, Organization, Call Log) based on our organizational chart.
Requirement Summary:
-
Hierarchical Access: Managers should be able to view all records created by or assigned to the users within their respective teams.
-
Restriction: Lower-level users should only have access to their own records.
-
Scope: This restriction must apply to all core CRM doctypes, including Lead, Deal, Task, Note, Organization, and Call Log.
-
Technical Expectation: We need the filtering to be handled dynamically via a
Permission Queryat the database level, based on the “Manager-Employee” relationship defined in the system.