Uploaded image for project: 'Xporter for Jira Cloud'
  1. Xporter for Jira Cloud
  2. XPORTERCLOUD-2234

When using dateformat function in an iteration inside an Excel cell, it only works if the iteration has more than one element

    XporterXMLWordPrintable

Details

    • Bug
    • Status: Testing (building)
    • Medium
    • Resolution: Unresolved
    • Xporter Cloud V 2.0
    • Continuous Delivery, FPC#5
    • Xporter Engine
    • None
    • UNCOVERED

    Description

      When using dateformat function in an iteration inside an Excel cell, it only works if the iteration has more than one element.

      If the iteration only has one element, then nothing is exported.

      Steps to reproduce:

      In column D, nothing is exported.

      Expected result:

      • All the dates should be exported with the applied format.

      Workaround:

      • Format the dates using Javascript. For example, for the format:
      ${dateformat("dd/MM/yyyy"):JQLIssues[i].Links[k].Created}
      

      We may use:

      %{"${JQLIssues[i].Links[k].Created}".substr(8,2) + "/" +"${JQLIssues[i].Links[k].Created}".substr(5,2) + "/" + "${JQLIssues[i].Links[k].Created}".substr(0,4)}
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            pmax Paulo Aleixo
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: