Dashboard Report with User ID Security

This public forum is for user-to-user discussions of PHPMaker. Note that this is not support forum.
Post Reply
shahparzsoft
User
Posts: 361

Dashboard Report with User ID Security

Post by shahparzsoft »

I have a Summary report with Graph Chart included.
That reports perfectly show data according to User ID hierarchy.

When we are using Dashboard Report as Vertical / Horizontal, it works fine
but when we use Dashboard Report as Custom then Hierarchy lost and showing all users data.
Please advise ?


shahparzsoft
User
Posts: 361

Post by shahparzsoft »

I have checked the SQL, it is ok in Dashboard Report and the Original Report.
Actually, if we show Graph and List both on Dashboard, then List loads according to User ID Hierarchy,
but graph ignores the User ID Hierarchy

sql: SELECT employees.employees_user_id, employees.employees_user_name, employees.employees_user_password, employees.employees_user_level, employees.employees_complete_name, employees.employees_mobile_number, employees.employees_email, employees.employees_activated, employees.employees_profile, employees.employees_reports_to, employees.employees_photo, employees.desig_id, employees.dept_id, employees.job_stastus, employees.employees_hire_date, employees.gross_salary, employees.leaves_sick_allowed, employees.leaves_sick_availed, employees.leaves_casual_allowed, employees.leaves_casual_availed, employees.job_nature, employees.kpi_calls, employees.kpi_meetings, employees.bank_accountno, employees.leaves_casual_balance, employees.leaves_sick_balance FROM employees WHERE (employees.employees_user_id = 17) OR (employees.employees_user_id IN (SELECT employees.employees_user_id FROM employees WHERE employees.employees_reports_to = 17)), executionMS: 0.0029709339141846

sql: SELECT employees.employees_user_id, employees.employees_user_name, employees.employees_user_password, employees.employees_user_level, employees.employees_complete_name, employees.employees_mobile_number, employees.employees_email, employees.employees_activated, employees.employees_profile, employees.employees_reports_to, employees.employees_photo, employees.desig_id, employees.dept_id, employees.job_stastus, employees.employees_hire_date, employees.gross_salary, employees.leaves_sick_allowed, employees.leaves_sick_availed, employees.leaves_casual_allowed, employees.leaves_casual_availed, employees.job_nature, employees.kpi_calls, employees.kpi_meetings, employees.bank_accountno, employees.leaves_casual_balance, employees.leaves_sick_balance FROM employees WHERE employees.employees_reports_to IN (17, 65, 14, 42, 26, 64, 74, 82, 86, 87, 95), executionMS: 0.00083279609680176


Webmaster
User
Posts: 9425

Post by Webmaster »

Please update to the latest template (Tools -> Update Template) and try again.


shahparzsoft
User
Posts: 361

Post by shahparzsoft »

Thanks. It works now.

Can template also update for Version 2022 ?

Any advise on this issue ?


mobhar
User
Posts: 11660

Post by mobhar »

I suggest you to contact Support. I have the best experience each time I contact them. Excellent support, as always.


Post Reply