Uploaded image for project: 'Elements Connect'
  1. Elements Connect
  2. CO-3582

Can't create / edit Issues when a Snapshot Date / Datetime field value is set, but empty

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: 6.0.1, 6.0.2, 6.1.5
    • Fix Version/s: 6.1.6
    • Labels:
      None
    • Functional components:
      Custom field - Date

      Description

      How to reproduce

      • Create an issue with summary "Issue not resolved"
      • Create a new Snapshot date field:
        • Datasource: Jira SQL
        • Query: SELECT resolutiondate FROM jiraissue WHERE summary = 'Issue not resolved'
        • Source field: RESOLUTIONDATE
        • Date format: Pattern
        • Date pattern: <empty>
      • Place the field on screens
      • Create an issue
      • Save

      Current

      The issue cannot be created: "Invalid date format. Please enter the date in the format "d/MMM/yy"."

      Same bug when an issue is edited:

      Expected

      • No error message
      • Field still return "No results"
      • Issue is created

      Workaround

      The issue occurs when a value is returned by the datasource, but the value is empty
      A workaround would be to filter out results where the date is empty.
      With the example given above, it would be:

      SELECT resolutiondate
      FROM jiraissue 
      WHERE summary = 'Issue not resolved'
      AND resolutiondate is not null
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              christophe.prome@valiantys.com Christophe Promé
              Reporter:
              nicolas.esteves@valiantys.com Nicolas Esteves
              Votes:
              2 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: