Excel jira.jql syntax documentation

Bill Somers
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 24, 2023

I can't find documentation of the Excel jira.jql function.  What does the "offset" parameter do?


jira jql.png

1 answer

0 votes
Aron Gombas _Midori_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 24, 2023

I couldn't find the doc, either, but I think "offset" is the index of first issue that matches the JQL which should be inserted to the Excel.

For example, if you have the CQL:

created > startOfYear() order by created

and you pass offset=100, maxRows=50, then even if the query matches 1000 issues (1000 issues created this year), only the 100th, 101th, ..., 149th will be inserted to Excel. In other words, you can control which partition should be inserted.

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events