Sorting by Updated Date & Created Date ignores second date

Question

Hi,

Trying to run this query:

project = INS ORDER BY updatedDate DESC, createdDate ASC

But the results are not being sorted by createdDate too only by the first date, updatedDate.

Are these standard JIRA fields?

Are they "Date" fields or just numbers or text fields?

Any ideas how to make this simple filter work?

unknown · Answer

Hi @David Clark,

You may want to raise this as a bug: https://support.atlassian.com/contact/#/

Apologies that I could not be of any more assistance

David Clark_afytw6 · Answer

Thanks but no its not grouping by date, it just seems to be ignoring the second sort parameter altogether.

unknown · Answer

Hi @David Clark,

Could it be the Timestamps that are included in the system fields; updatedDate & createdDate?

Does the updatedDate group in days correctly? If so, it could be the timestamp.

A similar question with a possible solution. You would need to create custom date field.

Hope this helps