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

XMLWordPrintable

    • 0
    • 1

      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

              Assignee:
              Daria Shatsylo (Inactive)
              Reporter:
              Earl McCutcheon
              Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: