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

Transition date format is incorrect when importing issues via JIRA JQL function on Sheets

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Low Low
    • None
    • 1.0
    • Jira Cloud for Google Sheets
    • None
    • Severity 3 - Minor

      Issue Summary

      You can get transition related fields from the issues when using Jira Cloud for Sheets, including the date for the transition by using the property Status Transition.date.

      Currently, if you use the JIRA JQL function to retrieve results, the Status Transition.date is returned on the wrong format (its database format).

      Steps to Reproduce

      • Access the Jira Cloud for Sheets app;
      • Enable the Jira function;
      • Perform a search as the following: 
        =JIRA("key= AV-6399", "key, transition.date")

      Expected Results

      The date format of the transition.date column will follow the other dates.

      Actual Results

      The format returned is the one as stored in the database:

      Workaround

      Use the JQL method to retrieve the results instead. Currently, the transition.date format is correct when using that method:

        1. Screen Shot 2021-03-30 at 14.57.53.png
          24 kB
          Leonardo De Almeida
        2. Screen Shot 2021-03-30 at 16.05.50.png
          321 kB
          Leonardo De Almeida

            [API-409] Transition date format is incorrect when importing issues via JIRA JQL function on Sheets

            Alexandre VANKEIRSBILCK -CROIX- added a comment -

            That would help a lot to have this.

            Alexandre VANKEIRSBILCK -CROIX- added a comment - That would help a lot to have this.

              Unassigned Unassigned
              lalmeida@atlassian.com Leonardo De Almeida
              Affected customers:
              3 This affects my team
              Watchers:
              2 Start watching this issue

                Created:
                Updated: