How to find a request that has changed from Open to Designing Tasks or Reviewing to Designing Tasks?

[Cory Britton]

Below is my current logic. I am trying to filter results to find all requests that have moved from open or reviewing to designing tasks in the last 7 days. 

The logic I am currently using is still only finding tasks moved from Open to Designing Tasks.  

type = Request AND status changed from "Open" to "Designing Tasks" after -7d AND status != Closed AND status != Withdrawn OR type = Request AND status changed from "Reviewing" to "Designing Tasks" after -7d AND status != Closed AND status != Withdrawn

[Pedro Felgueiras · Accepted solution]

Hi @Cory Britton

Without any plugins the best you can make is the use of the operator "was".  

Ex:

status was "Reviewing" and status = "Designing Tasks"

I know that isn't the same thing but i hope it can help. 

Best regards, 

Pedro 

[Cory Britton]

@Pedro Felgueiras could you be more specific? How would you write it?

[Cory Britton]

@Pedro Felgueiras never mind my logic was correct I just had a dunce moment.

This is the logic I ended up using. 

type = Request AND status changed from Open to "Designing Tasks" after -7d AND status != Closed AND status != Withdrawn OR type = Request AND status changed from Reviewing to "Designing Tasks" after -7d AND status != Closed AND status != Withdrawn ORDER BY key ASC

[Cory Britton]

@Pedro Felgueiras never mind my logic was correct I just had a dunce moment.

This is the logic I ended up using. 

type = Request AND status changed from Open to "Designing Tasks" after -7d AND status != Closed AND status != Withdrawn OR type = Request AND status changed from Reviewing to "Designing Tasks" after -7d AND status != Closed AND status != Withdrawn ORDER BY key ASC