Make Issue non archived scope to ancestors group archival compatible

What does this MR do and why?

Issue non archived scope to ancestors group archival compatible

Closes #585677 (closed)

Query Plans

• non-archived: https://console.postgres.ai/gitlab/gitlab-production-main/sessions/48346/commands/145388
• boardlist: https://console.postgres.ai/gitlab/gitlab-production-main/sessions/47261/commands/143192

References

Screenshots or screen recordings

Before	After

How to set up and validate locally

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.