Uploaded image for project: 'Atlassian Product Integrations'
  1. Atlassian Product Integrations
  2. API-505

using filtering in google sheets with transition reference returning random result set

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Low Low
    • None
    • None
    • None
    • Severity 2 - Major

      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

      1. create an issue
      2. Transition that issues 120 times (exe: ToDo > inProgress > ToDo > Repeat.....)
      3. link instance to google sheets
      4. 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

              Unassigned Unassigned
              emccutcheon Earl McCutcheon
              Affected customers:
              8 This affects my team
              Watchers:
              8 Start watching this issue

                Created:
                Updated: