Retrieve the newest date

[José Agnaldo B_ de Sousa]

Hi, I need a query to retrieve the issues that status changed to 'WCA' between the last 30 and 60 days

Note: In the example below, i had issues that has 2 lines with status changed to WCA and i need to use the date of the last line.

STATUS CHANGED FROM     STATUS CHANGED TO                    DATE
Resolved                                Waiting Customer Acceptance       01/12/2019
Resolved                                Waiting Customer Acceptance       20/04/2020

Thanks

[Zoryana Bohutska _SaaSJet_]

Hi @José Agnaldo B_ de Sousa 

You can consider add-on Issue History. It will let you view all issues which had changed statuses. To filter data only by two statuses you need, you can use export and then "play" with data at Microsoft Excel or Google Spreadsheet. I don't sure that it is what you need, but if you haven't other solutions, you can try it.

Regards

[Mohamed Benziane]

Hello @José Agnaldo B_ de Sousa 

You can try this :

status was changed to "Waiting Customer Acceptance" During (startofday(-60), endofday(-30))

This will show all issue that was to "Waiting Customer Acceptance) during the period you want. It will only retrieve the last time the issue was in this status.

Hope this helps

[José Agnaldo B_ de Sousa]

Hi Mohamed, thank you for the response but an error has occurred:

[Mohamed Benziane]

Sorry it's only status was "your status"

[José Agnaldo B_ de Sousa]

Thank you

I did this query to retrieve issues between 1 and 2 years but in the case bellow returns the issue with these dates, the last date is no more than 1 year. 

Status Changed From     Status Changed To                      date
Resolved                         Waiting Customer Acceptance    02/04/2019
Resolved                         Waiting Customer Acceptance    08/07/2019

status = "waiting customer acceptance" AND status was "Waiting Customer Acceptance" During (startofday(-730), endofday(-365))

[José Agnaldo B_ de Sousa]

@Mohamed Benziane

any idea to my problem ? it looks like it didn't work what you said above.

"It will only retrieve the last time the issue was in this status".

thank you very much.