Sorting by Updated Date & Created Date ignores second date

[David Clark]

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?

[Deleted user]

Hi @David Clark,

Would this example fulfil your requirements: 

project = EXAMPLE ORDER BY updatedDate DESC, created ASC

Hope this helps

[David Clark]

Thanks Danny, but...

That's basically the query I am using but the results show that its ignoring the second sort command ie "created ASC" or "createdDate ASC".

I also tried id ASC and its not working either.

The result set returns 4492 tickets, maybe its the volume of tickets that's cause the sort to fail?

[Deleted user]

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

[David Clark]

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

[Deleted user]

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