Jira filter search - Is there a way to limit the filter to only show 'x' issues?

[Lewis McNeil]

Hi everyone, 

Just a random one that I wasnt able to find any help on apologies if its clearly written somewhere. 

I am creating a JQL query which returns lets say 600 results. I want to assign these out to three individuals using bulk edit. But I dont want to click through 200 tickets each, as there is no way to single out these specific items. 

Is there a way for me to limit my search to 200 items then i can bulk assign this in three batches? So have a jql query to add in the end of my query to only return the first 200 tickets. 

Thanks in advance :) 

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @Lewis McNeil

a trick that I've been using in the past is to use a clause like

issuekey >= PROJ-1 AND issuekey <= PROJ-200

This works great if all relevant issues are from the same project and are numbered continuously; if that's not the case, you may have to play around with the parameters to get to the correct number of issues.

Hope this helps,

Hannes

[Hannes Obweger - JXL for Jira]

And just to add to the above: As Dan said, there are indeed Marketplace Apps that could help with this. I myself work on an app in which your use case would be trivial to solve: JXL for Jira.

For context, JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. Among many other advanced features, JXL also allows bulk editing via copy/paste. As you can update any number of issues in one action, you should be done with your work just in a couple of clicks.

Any questions just let me know,

Hannes 

[Lewis McNeil]

Hi @Hannes Obweger - JXL for Jira 

Thanks for the reply appreciate it, this might work well as I can set a range and then just increase or decrease to arrive at the right amount of tickets necessary.

Will also check out the third party tool? Not sure how using 3rd party tools and the additional cost they will incur so will check it out. 

Cheers, 

Lewis

[Dan Breyen]

Hi Lewis, I did a quick search in Atlassian's Jira site and found this ticket: JRACLOUD-73303 

I'm pretty sure there are third party tools that would provide this, but I'm not aware of anything in the base code.

Hope that helps.