WHY? Part of the query on [table] has been ignored because of read security rules on [table]

Desmo
Mega Guru

‎03-29-2022 01:52 PM

Hello Community,

Looking for insight from the community.

The situation:

  1. Table field read ACL for specific roles [let's call it f1/field_1]
  2. Report contains f1 on list
  3. Report has default sort using using f1
  4. Report added to dashboard widget
  5. User views dashboard and widget
  6. Widget and report loads
  7. Widget displays message: "Part of the query on [table] has been ignored because of read security rules on [table]" [Expected behavior. See image.]
  8. Report does not return any rows
  9. Only when user selects a choice from the Group by does the report load (minus the f1) [see image]

Initially, I thought it was the sort causing the problem. I updated the report using another field to sort. This did not affect the behavior mentioned above. 

I would like to understand why doesn't the list just load [minus the f1] without having the user change the Group by in order to see the list.

To users, it's not intuitive--it's more inconvenient. 

find_real_file.png

 

Thank you.
Desmo

Labels:
Preview file
17 KB
0 Helpfuls
  • 2,057 Views
1 REPLY 1

Filipe Cruz
Kilo Sage
Kilo Sage

‎03-29-2022 02:14 PM

Hello Desmo,

Just a suggestion: disable the different read ACLs from that table and test to see if the issue continues.
If not, start activating each ACL until you detect the one that is causing the issue.

Then, you can share again here your findings so we can help you!

Please, if this answer is relevant for you, please mark it as correct and helpful.

Thanks,

Filipe

0 Helpfuls