Details
-
Bug
-
Resolution: Unresolved
-
Low
-
None
-
None
-
None
-
Severity 2 - Major
Description
Issue Summary
Using an =jira() filter in google sheets that contains a transition field or subfield reference will only return a truncated list of the transitions, the number of transitions returned is verified to occur in varying quantities on different issues but can reliably return only 100 transitions where 120 exist using the steps described below but we have seen as few as 4 transitions returned where 7 transitions existed on an issue as well as only 70 transitions returned where 100+ transitions exist.
Steps to Reproduce
- create an issue
- Transition that issues 120 times (exe: ToDo > inProgress > ToDo > Repeat.....)
- link instance to google sheets
- use a =jira() search that includes transitions field results example:
=jira("key=EXAMPLE-1","issuekey,transition.authorEmail,transition.id,transition.authorDisplayName,transition.to,transition.date",,)
Expected Results
all transitions of the specified issue are returned
Actual Results
only a portion of the issues transitions are returned in the data set, noting again that in the example above 100 out of 120 transitions are returned but in other reported cases, the number of returned results have been widely random and the exact cause of the randomness is yet to be identified
No log exceptions have been found at this point.Workaround
Currently, there is no known workaround for this behavior. A workaround will be added here when available