Scripted Paragraph field to return results based on JQL

[Priyanka Agrawal]

I am looking for a script to display all the issues returned by the below JQL in a scripted paragraph field and, if possible, the result should be rendered inside the "Jira issues" macro.

JQL:

project = TRAV AND 'Account ID' ~ "${accountId}"

Here, 

"${accountId}" is the account ID of the current issue where the scripted field is present.

Please help me with this.

[John Funk]

Hi Priyanka,

You won't be able to do that with a simple JQL query. You might can get what you want by creating an automation rule using lookupIssues functionality and update the paragraph field with the list of issues returned from the lookupIssues. 

[Priyanka Agrawal]

Thanks @John Funk ,

The solution partially works. It fetches data using lookupIssues. But I don't know how would that work when there are more than 5000 issues fetched by the lookupIssues. Also, do you know how to present the result in a tabular format using automation in the paragraph field?

[John Funk]

You would definitely need to filter down the results of the lookupIssues. And sorry, I don't have experience with the tabular format. 

@Bill Sheboy 

[Bill Sheboy]

Hi @Priyanka Agrawal and @John Funk 

For the table, you could use the markdown inside the iteration of the lookup results:

https://jira.atlassian.com/secure/WikiRendererHelpAction.jspa?section=tables 

Regarding the issue limits, Lookup Issues can return up to 100 issues to a rule. 

The new issue search REST API endpoint can return up to 5000 issue ID values, but as soon as any field other than ID or Key are included in the results, the limit drops back down to 100 issues, requiring paging.  And so there is no workaround for an automation rule.

Kind regards,
Bill