Context
We are using Odoo 9 Contracts Management functionality and need to record timesheets with tasks. As this is not possible in the default entry form (see this post: https://www.odoo.com/forum/help-1/question/record-activities-time-against-project-tasks-in-odoo-9-timesheets-92869 ) we need to use the Activities view, which shows entries from the Analytic Account Line data model.
Problem
The current Activities view shows all records (all activities from all users for all analytic accounts).
We want to show:
The entries related to that user
The entries related to employees that user manages, and
The entries related to Analytic Accounts / Projects Managed by the User
All entries when user is part of a specific Permissions Group (e.g. Human Resources / Manager, etc)
So Far...
We are using the record rules to filter what the user can see and are building this up step by step
We can successfully filter entries related to the user: [('user_id','=',user.id)]
We tried to also filter where the user was the manager, but failed with many variations of the following: ['|',('user_id','=',user.id),('user_id.manager_id','=',user.id)] and ['|',('user_id','=',user.id),('user_id.employee_ids.parent_id','=',user.id)] and ['|',('user_id','=',user.id),('user_id.employee_ids.parent_id','child_of',user.id)] etc etc
We get exceptions like: "user_id" not found in "hr.employee" table when using the child_of method, other times it will say no such field/leaf, and yet other times it will not report an error but wont show the expected records either.
Clearly we are just not understanding how to relate to the ORM model, but the documentation we've found doesn't seem to help a great deal (maybe we've missed something though).
Any help or guidance appreciated!