Draft: fix: align issue counts between sidebar and homepage
Relates to issue #569484 (closed)
This MR was created by Duo in Session 1116924
Changes
- Investigate and align issue count implementations between sidebar and homepage
- Ensure consistent query logic for assigned issues across both locations
- Address discrepancies in issue counting methodology