Stories from external epics disappear in swimlanes

Summary

When Swimlanes are based on Epics and there are Issues linked to Epics which are not available in the board, then these Issues are still visible in Backlog (for Scrum) & Kanban Backlog (Kanban) but invisible in Active Sprints (both Scrum and Kanban)

Steps to reproduce

1. Create board A (Scrum) for project A, which should filter all issues in project A
2. Create project B, then create Epic B in project B
3. Create Issue A in project A, then link it to Epic B
4. Create a sprint in board A, add Issue A to it and start it
5. Configure board A and base Swimlanes on Epics

Steps to reproduce (scenario 2)

1. Create a new Kanban project using the sample issues template.
2. Remove Kanban board sub-filter via board > configure > general.
3. Configure "Hide completed issues older than" to show all option.
4. Create a filter like this -> project = ABC and updated >= -100d order by RANK asc
5. Configure board base Swimlanes on Epics
6. Create a new Epic in the kanban backlog.
7. Create a new stories via CSV import by changing the date creation and date updated to order than 100 days.
   • Make sure you have the stories linked to the Epic Link and set the issue status to the "In Progress" category status.
   • For example, the CSV format (note the date is older than 100 days):

     Summary, Assignee, Reporter, Issue Type, Epic Name, Description, Priority, Created, Updated, Epic Link, Status
     "Test issue 1", admin, admin, Story, Story test 1,,,10/01/2023,06/03/2023, KAN-18, "In Progress"
     

1. In the work mode (clicking Kanban board at the side bar), the new Epic is missing or disspear from the board.

Expected behavior

Issue A is visible in Active Sprints of board A

Actual behavior

Issue A is invisible in Active Sprints of board A

If Issue Count is enabled for the Columns, we can see a mismatch in the number of issues like this:

In Backlog mode, all the 4 issues are visible:

Notes

The same behavior applies to both Scrum and Kanban boards

Original Description