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 Champions.
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
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 Champions.
September 14, 2020

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

Jack Brickey
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 Champions.
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