I am trying to create a filter between two projects that will give me a list of task where the status in project 1 is not in a given status and is in a given status in project 2. I have tried a few different ways but have not been able to figure it out.
project in (Project_1, Project_2) AND status not in "Joe Complete" AND status in "Mark Complete")
Hello @Roger Hancock
Have you tried this query:
(project = Project_1 AND status != "Joe Complete") OR (project = Project_2 AND status = "Mark Complete")
Please tell me if I misunderstood your requirements and I will get back to you and try to come up with a solution!
Just add summary ~ your_summary where depending on where you want it. If you want it to be for both projects you should add it after the last paranthesis so it looks like this:
(project = Project_1 AND status != "Joe Complete") OR (project = Project_2 AND status = "Mark Complete") AND summary ~ "your summary"
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events