Performance on Investment-based sub-objects is bad compared to project-based sub-objects when no global rights are granted to the user.
When OBS level access rights are granted, performance degrades if the sub-object belongs to the Investment object, opposed to the Project based sub-objects
STEPS TO REPRODUCE:
- Go to Administration, Studio: Objects
- Create a new object that is a sub-object of Investment: KPI Inv
- Create a second object that is a sub-object of Project: KPI Prj
- Both objects will be available to the project object
- Create a user (user1) assigned to the following rights:
- OBS level: Project – View
- Global: Projects - Navigate
- Global: KPI Inv – Create
- Global: KPI Prj – Create
- As an admin user, go to a project that belongs to the OBS the user has access
- Create a few instances of both sub-objects
- Log in as the user1
- Go to the project where sub-object instances have been created
- Navigate to the project sub-object list - KPI Prj
- Click on Filter, Show all, use the filter fields like ID and filter - the performance is okay
- Navigate to the investment sub-object list - KPI Inv
- Click on Filter, Show all, use the filter fields like ID and filter
Expected Results: Performance is similar as to the project sub-object
Actual Results: Performance is bad compared to the project sub-object