paginating the results automatically in JIRA cloud for Gsheets

sharmila leo

how to use the =JIRA() function which lets to paginate through results. 

For example, to return 20000 issues, put this on one cell to return the first 10,000 issues: 

=JIRA("project = ProjA order by updated desc", "", 0, 10000) 

And this in another cell to return the following 10,000 issues: 

=JIRA("project = ProjA order by updated desc", "", 10000, 10000) 

 

But how i can automate this formula in the gsheet cells to paginate by 10000

Joseph Chung Yin

@sharmila leo -

Welcome to the community.  It seems you are using a function call provided by a third party add-on or by your own custom development.  Jira() function is not something out of the box from Atlassian.  

By default,  when you use the filters menu in the JSM product project UI and search for issues, the pagination in the UI is displaying 100 issues at a time.

Therefore you need to contact the add-on vendor or your own development team to obtain further technical support.

Sorry.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Technology Applications Team

Viasat Inc.