Resolve "Open issues from archived project listed in group issue board"

What does this MR do?

When viewing a group issue board, filter out any issues from archived projects. Also ensure that the dashboard header issue and mr counts do not count archived projects.

What are the relevant issue numbers?

Closes #45754 (closed)

Does this MR meet the acceptance criteria?

• Changelog entry added, if necessary
• Documentation created/updated
• Tests added for this feature/bug
• Conforms to the code review guidelines
• Conforms to the merge request performance guidelines
• Conforms to the style guides
• Conforms to the database guides