nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

In advanced search how do I check for a text field having no text?

Eric Chamberlain_jiucs2

I am trying to search for stories that have an empty "Acceptance Criteria" but nothing is working. I have tried

"Acceptance Criteria" is EMPTY
"Acceptance Criteria" !~ "?"

I have done other tests to confirm that I have the right field by searching for a specific sub-text and seeing the results.

Additional information:

If I try

"Acceptance Criteria" = ""

I get the error

The operator '=' is not supported by the 'Acceptance Criteria' field.

Accepted answers

All comments

Ditte Simard

the "=" operator does not work with a text field. You would have to use "CONTAINS" (which is the ~) : https://support.atlassian.com/jira-service-management-cloud/docs/advanced-search-reference-jql-operators/#Advancedsearchingoperatorsreference-CONTAINS

Unfortunately there isn't a clean way to check if a text field is empty. I would recommend that you check this article out as well: https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-fields/#Text

Kai Becker

Hi @Eric Chamberlain ,

for multiline text fields,

"Acceptance Criteria" is EMPTY

should do the trick. Just to be sure, are you using Jira cloud or an on prem version?

What type of field is "Acceptance Criteria"?

Eric Chamberlain_jiucs2

As stated in the question body, I have tried that expression and it does not filter as one would expect.

Eric Chamberlain_jiucs2

The "~" operator is a synonym for CONTAINS as documented in that link. I have tried it and it does not work.

Eric Chamberlain_jiucs2

I am beginning to think that the behavior is a JIRA bug. Otherwise, what does

"Acceptance Criteria" is EMPTY

mean?

Ditte Simard

Do you get an error when you do:

Acceptance Criteria is EMPTY

Or are you getting results that you are not expecting?

Eric Chamberlain_jiucs2

It is the latter. I get results have various amounts of text in the field. The search constraint seems to be ignored.