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

[mak kam]

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]

Just look at the board? ;-)

Seriously, if you're able to code, using the REST API you can get all the issues in a sprint and extract the info from that

[mak kam]

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.

[Warren]

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]

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