Uploaded image for project: 'Jira Software Data Center'
  1. Jira Software Data Center
  2. JSWSERVER-16568

JQL Documentation need clarification on the DOES NOT CONTAIN: !~ variable

XMLWordPrintable

    • 0
    • 1
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      Problem Definition:

      The KB Advanced searching - operators reference For the *DOES NOT CONTAIN: Unable to render embedded object: File (~* operator variable there needs to be clarification on the results of EMPTY values, all the other NOT reference examples () not found.= , NOT IN, IS NOT, WAS NOT, WAS NOT IN) include this information to include the EMPTY set just not for the !~ section

      For the The Example:

      Note that for version fields, the ~ operator returns an exact match. For example, to find issues where Fix Version is not "9.0", you would use the following query:

      fixVersion !~ "9.0"

      This JQL Would be any issue that has a value in the fix version field that is not 9.0 but would not include issue where the FixVersion field was empty to do this the Filter would need to include:

      fixVersion !~ "9.0" OR fixVersion is empty

      The main take away is that when you are using a Exclude statement in JQL the Logic is such that a value is expected in the Field that does not match the value given, so you must include an additional search for the Empty set as NULL is not a value

            [JSWSERVER-16568] JQL Documentation need clarification on the DOES NOT CONTAIN: !~ variable

            Daria Shatsylo (Inactive) made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: Waiting for Release [ 12075 ] New: Closed [ 6 ]
            Daria Shatsylo (Inactive) made changes -
            Status Original: In Progress [ 3 ] New: Waiting for Release [ 12075 ]
            Daria Shatsylo (Inactive) made changes -
            Fix Version/s New: 8.13.0 [ 91997 ]
            Fix Version/s New: 8.14.0 [ 92898 ]
            Fix Version/s New: 8.15.0 [ 92947 ]
            Fix Version/s New: 8.16.0 [ 94593 ]
            Fix Version/s New: 8.17.0 [ 94802 ]
            Fix Version/s New: 8.18.0 [ 95094 ]
            Fix Version/s New: 8.19.0 [ 95693 ]
            Fix Version/s New: 8.20.0 [ 95694 ]
            Fix Version/s New: 8.21.0 [ 97590 ]
            Fix Version/s New: 8.22.0 [ 98792 ]
            Fix Version/s New: 9.0.0 [ 97892 ]
            Fix Version/s New: 9.1.0 [ 99994 ]
            Fix Version/s New: 9.2.0 [ 101712 ]
            Fix Version/s New: 9.3.0 [ 102403 ]
            Fix Version/s New: 9.4.0 [ 102404 ]
            Fix Version/s New: 9.5.0 [ 102893 ]
            Fix Version/s New: 9.6.0 [ 104017 ]
            Daria Shatsylo (Inactive) made changes -
            PM Reviewed New: 31/Jan/2023
            Status Original: Gathering Interest [ 11772 ] New: In Progress [ 3 ]
            Daria Shatsylo (Inactive) made changes -
            Assignee Original: Tomasz Bartyzel [ tbartyzel ] New: Daria Shatsylo [ 500376cac1e1 ]
            Daria Shatsylo (Inactive) made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 726210 ]
            SET Analytics Bot made changes -
            UIS Original: 1 New: 0
            Katherine Yabut made changes -
            Workflow Original: JAC Suggestion Workflow [ 3064961 ] New: JAC Suggestion Workflow 3 [ 3660579 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing v4 [ 2663440 ] New: JAC Suggestion Workflow [ 3064961 ]
            SET Analytics Bot made changes -
            UIS Original: 0 New: 1

              500376cac1e1 Daria Shatsylo (Inactive)
              emccutcheon Earl McCutcheon
              Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: