Agile - Get Story/Task which has maximum/ minimum estimation point in a scrum board

Question

I need to get the issue which has the maximum/minimum estimation point within a scrum board.

I couldn't find any suitable API(Not even using jql) to achieve this task.

Is it possible ? If not please suggest an alternative way to do this.

Thanks in advance. Cheers!!!

Arun

Warren_mz9b4z · Answer

Did you not see the second line of my answer which basically told you to do exactly what you've now said works for you?? I said use the REST API which is how you've solved it!

mak kam · Answer

I have found out a solution. Seems to be working.

Values needed:

Custom field id used to denote the estimation point(This can be found using https://docs.atlassian.com/jira-software/REST/2017-09-19T00:01:13Z/#agile/1.0/board-getConfiguration)

Issue in a board with MAX estimation point

https://XXX.atlassian.net/rest/agile/1.0/board/5/issue?startAt=0&maxResults=1&jql=cf[10014]!=null%20ORDER%20BY%20cf[10014]%20DESC

Issue in a board with MIN estimation point

https://XXX.atlassian.net/rest/agile/1.0/board/5/issue?startAt=0&maxResults=1&jql=cf[10014]!=null%20ORDER%20BY%20cf[10014]%20ASC

mak kam · Answer

Seriously, are you kidding me???

Say there is a scrum board with 'x' sprints with each having 'y' items and a backlog with 'z' items.

Now you want me to process x*y + z items just to find the item with max/min estimation points from a single scrum board

Then what is the use of 'jql' ?

I was expecting if I could just sort the issues by estimation points with 'maxresult' as 1 and start index as '0', if you know what I mean.

Your solution is not at all efficient.