Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Please help with a JQL Query

Joe
Contributor
September 14, 2020

I have the following query that searches for two custom fields

project in ("Project") and ("Field1") and ("Field2") is not EMPTY


When I try the query below it works, I just can't seem to figure out how to search two custom fields. I tried with and without () also with and without "". I am trying to search for any fields that are not empty but have multiple fields to search. 
project in ("Project") and "Field1" is not EMPTY

Any suggestions? 

3 answers

0 votes
Alsa Pedone October 19, 2021

This worked for me.

(project in ("Project") and "Field1" is not EMPTY) OR (project in ("Project") and "Field2" is not EMPTY)

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 15, 2020

The problem is that you've only got half a clause in your query:

  • Project in () - selects for projects
  • and
  • ("Field1") - and field1 what?
  • and
  • ("Field2") is empty - checks if field 2 is empty

As you entered this into the JQL box, it would have told you that "and" was wrong after the end of that clause.

0 votes
Jack Brickey
Community Champion
September 14, 2020

Project = xxx and custom1 is not empty and custom2 is not empty And custom3 is not empty...

Jack Brickey
Community Champion
September 14, 2020

Use of quote for custom field is optional if the field is a single word but required if multiple words.

Suggest an answer

Log in or Sign up to answer