I started my system with version 7.9.0. I have upgrade 7.10 in 04/2019 and 7.11.3 in 05/2019.
And when i check some simple report (Module report), normal user can not see any result. All report have relationship field all die with normal user, admin still ok
With report Opportunity (Opp Name, Account Name, ⌠some Opp fields), Log file appear error with query:
I think error in query generated: [quote]"LEFT JOIN [color=red]accounts opportunities:accounts[/color] ON opportunities:accounts.id=opportunities|opportunities:accounts.account_id AND opportunities:accounts.deleted=0
AND ( [color=red]accounts.assigned_user_id[/color] =âb1c16b21-c717-7d66-7795-5c948a1488b4â or "[quote]
âaccountâ need change to allias opportunities:accounts . If i change like that, query can success to get result
With report Tasks (related Opportunities), same error:
LEFT JOIN [color=red]opportunities tasks:opportunities[/color] ON tasks.parent_id=tasks:opportunities.id AND tasks:opportunities.deleted=0
AND tasks.parent_type = âOpportunitiesâ
AND ( [color=red]opportunities.assigned_user_id[/color] =âb1c16b21-c717-7d66-7795-5c948a1488b4â or EXISTS (SELECT 1
=> MySQL error 1054: Unknown column âopportunities.assigned_user_idâ in âon clauseâ