Draft: fix: align issue counts between sidebar and homepage
Relates to issue #569484 (closed)
This MR was created by Duo in Session 1116933
Changes
- Investigate and fix discrepancies between issue counts shown in sidebar vs homepage
- Ensure both locations use consistent query implementations for issue counting
- Align count calculation logic between super sidebar and homepage widgets