Retrieve the newest date

Question

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_ · Answer

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

José Agnaldo B_ de Sousa · Answer

@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.

José Agnaldo B_ de Sousa · Answer

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