nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

#lookupIssues - Is there any way to get more than 100 as a result?

Jose Ariel Laureano Ramirez

I'm working with a large number of incidents that I'd like to send via email and I'm currently using #lookupIssues and it works perfectly, the only issue is that it only returns 100 items.

Any ideas???

Accepted answers

Bill Sheboy

Hi @Jose Ariel Laureano Ramirez

Short answer: no.

Even though Lookup Issues returns a limited set of fields from issues, automation rules are limited to the number of issues returned/impacted...most likely for performance reasons and accuracy (data could become out of date by the time the rule finished otherwise).

What problem are you trying to solve my sending all of those issues in one email? Describing that may help the community offer you alternative ideas to the big batch of issues. Thanks!

Best regards,
Bill

All comments

Bill Sheboy

Hi @Jose Ariel Laureano Ramirez

Short answer: no.

What problem are you trying to solve my sending all of those issues in one email? Describing that may help the community offer you alternative ideas to the big batch of issues. Thanks!

Best regards,
Bill

Jose Ariel Laureano Ramirez

Thanks @Bill Sheboy

Well I want to send via email a weekly report with a group of tickets based on the result set of a query but the amount of tickets is over 100, lets say around 200. The automation works perfectly but the issue is that it only send 100 items or less.

Bill Sheboy

Thank you for explaining further.

Possible work-arounds are to:

find ways to identify sub-sets of the results, and use multiple Lookup Issues JQL calls to pull the results in chunks
use the REST API to get the count of issues, sent the report, and conditionally add a statement and filter to the email: "There are more than 100 issues, and only the first 100 are shown. Please check this filter to see the remaining issues: <filter link>"
investigate marketplace addon reports which are not limited by 100 issues

Jose Ariel Laureano Ramirez

Thanks @Bill Sheboy

Benjamin Baker_qxzvlr

I figured out a way to get around the 100-issue limit, check out the post I just made: Enabling pagination over 100 issues in the Jira Lo... (atlassian.com)