Creating a filter in two different projects.

[Roger Hancock]

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")

[Alexander Ling]

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!

Best regards,

Alexander

[Roger Hancock]

That worked.

One more variable that I would like to add to this filter would be to compare the summary and only return those where the summary's match.

[Alexander Ling]

Hello!

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"

Best regards,

Alexander