[backend] Fix distribution widget by creator error (#9117)

[SouadHadjiat]

Proposed changes

• filter out unresolved data (like the SYSTEM user) before testing user access on element

Related issues

Check the issue for repro steps

• 9117

Checklist

• [x] I consider the submitted work as finished
• [x] I tested the code for its functionality
• [ ] I wrote test cases for the relevant uses case (coverage and e2e)
• [ ] I added/update the relevant documentation (either on github or on notion)
• [ ] Where necessary I refactored code to improve the overall quality

Further comments

I think we might need to fix this issue differently at some point. Right now it will display the same data as for admin users, but it's missing all the data created by system users which I think we should display.

Sorry I didn't write any integration test for this, it would take a lot of time since audit logs resolver test doesn't even exist, and I would need to fill the database with data created by internal users (currently everything is created with admin)

[codecov[bot]]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 64.97%. Comparing base (402d6bc) to head (749ca1d).

Additional details and impacted files

```diff @@ Coverage Diff @@ ## master #9118 +/- ## ======================================= Coverage 64.97% 64.97% ======================================= Files 623 623 Lines 59496 59496 Branches 6577 6579 +2 ======================================= Hits 38656 38656 Misses 20840 20840 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

---

🚨 Try these New Features:

• Flaky Tests Detection - Detect and resolve failed and flaky tests
• JS Bundle Analysis - Avoid shipping oversized bundles