I am trying to filter the issue based on days/hours spent on it In Asc order

[shashi_prasad]

I am trying filter out the issues in a particular project in ascending order by the time used in that issue.

project = TS ORDER BY ... what would be the syntex here?

[Petter Gonçalves]

Hello @shashi_prasad

Thank you for reaching out.

Per your description, I understand you want to search for issues in JQL, ordering them by the amount of time logged. Is that correct?

You can achieve that by using the timespent field. This would be the syntax:

ORDER BY timespent ASC

P.S: the field above is only applicable for issues where some work was logged. For issues with no work logged, they will be ordered to the end of the query.

Let us know if you have any questions.