Issue Summary

JCMA is not able to finish running the preflights in case it contains a filter with "WAS NOT IN" or "WAS IN", and other filters have a reference to it.

Steps to Reproduce

1. Install any version of JCMA greater than 1.11.0 (could be the latest one).
2. Navigate to the Migration Assistant home, create a migration plan including all boards and filters on it
3. Run the preflight checks
4. Check that cross-project boards and filters preflight check failed

Example Data used to Reproduce the issue

1. Create a project with key KANBAN
2. Create 4 issues for this project
3. Create at least 4 filters with the following configuration:
   • KANBAN_1: filter != KANBAN_2 AND filter != KANBAN_3 AND filter != KANBAN_4 ORDER BY created DESC, updated DESC, status DESC, Rank ASC
   • KANBAN_2: Filter = KANBAN_3 OR Filter = KANBAN_4 OR Filter = KANBAN_3 OR Filter = KANBAN_4 OR Filter = KANBAN_3 OR Filter = KANBAN_4 ORDER BY created DESC, updated DESC, status DESC, Rank ASC
   • KANBAN_3: project = KANBAN AND (resolved >= 2022-01-01 AND resolved < 2025-12-31 OR resolved is EMPTY) AND (resolution != duplicate OR resolution is EMPTY) AND priority in (Highest, High, Medium) AND (labels not in (frictionpoint) OR labels is EMPTY) AND status was not in (Closed, Resolved) ORDER BY created DESC, updated DESC, status DESC, Rank ASC
   • KANBAN_4: project = KANBAN AND (resolved >= 2022-01-01 AND resolved < 2023-12-31 OR resolved is EMPTY) AND Status in (Backlog,Done,"In Progress",Open,Resolved) OR project = SCRUM AND (resolved >= 2022-01-01 AND resolved < 2023-01-01 OR resolved is EMPTY) AND Status was in (Backlog,Done,"In Progress",Open,Resolved) AND status in (Closed) ORDER BY key ASC, created DESC, updated DESC, status DESC, Rank ASC

Expected Results

The preflights should be able to run successfully on this scenario.

Workaround

Not include boards and filters on the migration plan, or contact Atlassian support team for additional help.