Custom Field and Aha Integration

[Drishti Maharaj]

Hi,

We have a custom number field create don JIRA that is populated with a number form our Aha Integration.

This is a negative (-) number.

The issue is that if you try to sort this on the board in the project, it does not sort in order.

How do we get it to sort in the right order? 

[Nic Brough -Adaptavist-]

When you say "custom number field", exactly what type of field is it in Jira?  

Can you go to Admin -> Issues -> Custom fields, find it in the list, and look beneath its name for the field type?  What does that say exactly?

[Drishti Maharaj]

It is a number field with the search template set to number searcher. 

[Nic Brough -Adaptavist-]

Ok, great, can you tell us what is wrong with the sort, and how you are doing the sort?

[Drishti Maharaj]

Apologies for getting back to you so late.

The query is as follows:

project = project_name AND Sprint in (openSprints()) ORDER BY "Aha Rank" DESC

The "Aha Rank"  is the custom field with negative numbers on the query it looks like this and sorts as it should. If I save this filter query though however and add it to my board, then the issues show all out of order and not in sequence.

My board is configured in the swim lanes according to stories, ranking is disabled

[Nic Brough -Adaptavist-]

If ranking is disabled but you're putting things into swimlanes, then what are you actually sorting against?

[Drishti Maharaj]

They are trying to sort it according to the custom field called Aha Rank which is the numbers. 

[Nic Brough -Adaptavist-]

The swimlanes effectively become the primary sort within your board if you use them, so can you show us what a sort within one looks like?

[Drishti Maharaj]

On the board, the issues are shown like a list and the Aha Rank is not in sequence as the image...it should be -1, -2, -3, etc but it is not.

They want the board to look like it is a list unfortunately so that is why it is configured as that.

If there is a way to make it look the same but have the issues in the right order as per the Aha Rank, I am not too sure how to get it that way.