Does the query of items that are checked/non-checked/mandatory from a checklist custom field work?

Hello,

 

When trying to perform a search to find all issues that have the option "Integrated" checked in the list of the custom field "DoD" , we receive the below error. 

I tried to search for similar issues, found that ScriptRunner might be causing this and that the solution would be to update it. I updated it and this still persists.

 

image2016-7-11 13:56:12.png

 

2 answers

Hi Christina,

Can you provide me the link to the articles you mention. Also, can you take a look a the log file and provide any errors related to the issue at hand?

Thanks

@Whyves

Hello,

This is the article, but I believe it's not the same issue, this is why it didn't help: How do I fix the this error message: Unable to find JQL function 'addedAfterSprintStart .

Please see below the contents of the .har file which I used to record what happens when try to perform the query:

 

POST QueryComponent!Jql.jspa
500 Internal Server Error
3.7 KB
 
40.4ms
 

 

Response Headers
Date
Mon, 11 Jul 2016 13:25:15 GMT
Content-Encoding
gzip
X-Content-Type-Options
nosniff
X-AREQUESTID
985x96516x1
X-ASEN
SEN-5132028
Connection
close
Content-Length
3759
Pragma
no-cache
Server
Apache-Coyote/1.1
X-Seraph-LoginReason
OK
Vary
User-Agent
Content-Type
text/html;charset=UTF-8
Cache-Control
no-cache, no-store, must-revalidate
X-ASESSIONID
3f20ey
X-AUSERNAME
amihai
Expires
Thu, 01 Jan 1970 00:00:00 GMT
Request Headers
Cookie
atlassian.xsrf.token=BBLX-LXU1-FA7V-BPKP|2494365080c4d2237279ab9edca2df2ada8a70b8|lin; gh.i=%7B%7D; LtpaToken2
=SjrNyQj5Et2GkJv1qrCZ1LTeslPHt1pqqi9Ku+INEsSEec1DNWJoUWh4HWN+JzUteMDkXTO1f1cD9B+PoN+TkZYDZl2lsUF8AWP2bPeEsgWVmp5su6vx
+S+BCmEE3q1CUp2pKvDgEoQ3Vouib/5on3jPKvlSUGcVi5GSznAruqhfMf6sqywZTBA7eW+sLKOjC2jFY/3vLGvazXurRi6h7qLAQwutyMUbWjql7hRuStJo1Qm8gW5ePZPc13CKpuWixrFqFJly6nwO
+MjHPJiUPqGnFIed7Q9DIFnNync29yGs1Kmd02EXJ5MtOGXnFYQhb94/m4qWBFoPT5NgbRzudYu2Ob2FQotoTMzQLvYzz20=; LtpaToken
=/hDbBRFtGu6yFiYpCwijT2XsHyLXVjL0r0wu6rMSvLBQjRfYfU4bfOIw9I5C+RKQPd+KXuIJ1k385frGAbMUPktg88q/xdlkqrALHvF70J2K80BMnPyiNKRhL7aBRdzO9x4l
+tlOZ6odoDjXQXrdE8l160uVuAC6EEjb0vcRsLtGOl/fLQ4sAy68UL8KGKMLvoriYVP3SrNlSyct5yn4aOqCNGCcxZOqPRofPxhaHL4Iy3oetpEpym5
+6NMZk5SsSFe5Or5E8wEmuOwKatoowndPYD6VaRJ6mFnynlouyWr6vW4soPPPW6r4i/amZ7gvu8/Zr/5QkSs=; lcLang=en_us;
 DWRSESSIONID=lWvVZ*2D6t6WS657Kx7cXgy4gkl; JSESSIONID=94FCBF5F9DEB1001A76B217B394E4112
Origin
http://iasp091x.ia.ro.conti.de:8080
Accept-Encoding
gzip, deflate
Host
iasp091x.ia.ro.conti.de:8080
Accept-Language
en-US,en;q=0.8,ro;q=0.6
User-Agent
Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari
/537.36
Content-Type
application/x-www-form-urlencoded; charset=UTF-8
Accept
*/*
Referer
http://iasp091x.ia.ro.conti.de:8080/issues/?jql=DoD%20%3D%20checkedItem(Integrated)
X-Requested-With
XMLHttpRequest
Connection
keep-alive
X-SITEMESH-OFF
true
Content-Length
50

 

 

POST issueTable
400 Bad Request
169 B
 
21.6ms
 

 

Response Headers
Date
Mon, 11 Jul 2016 13:25:15 GMT
Content-Encoding
gzip
X-Content-Type-Options
nosniff
X-AREQUESTID
985x96517x1
Transfer-Encoding
chunked
X-ASEN
SEN-5132028
Connection
close
Server
Apache-Coyote/1.1
X-Seraph-LoginReason
OK
Vary
User-Agent
Content-Type
application/json;charset=UTF-8
Access-Control-Allow-Origin
http://iasp091x.ia.ro.conti.de:8080
Cache-Control
no-cache, no-store, no-transform
Access-Control-Allow-Credentials
true
X-ASESSIONID
3f20ey
Access-Control-Allow-Headers
Content-Type
X-AUSERNAME
amihai
Request Headers
Cookie
atlassian.xsrf.token=BBLX-LXU1-FA7V-BPKP|2494365080c4d2237279ab9edca2df2ada8a70b8|lin; gh.i=%7B%7D; LtpaToken2
=SjrNyQj5Et2GkJv1qrCZ1LTeslPHt1pqqi9Ku+INEsSEec1DNWJoUWh4HWN+JzUteMDkXTO1f1cD9B+PoN+TkZYDZl2lsUF8AWP2bPeEsgWVmp5su6vx
+S+BCmEE3q1CUp2pKvDgEoQ3Vouib/5on3jPKvlSUGcVi5GSznAruqhfMf6sqywZTBA7eW+sLKOjC2jFY/3vLGvazXurRi6h7qLAQwutyMUbWjql7hRuStJo1Qm8gW5ePZPc13CKpuWixrFqFJly6nwO
+MjHPJiUPqGnFIed7Q9DIFnNync29yGs1Kmd02EXJ5MtOGXnFYQhb94/m4qWBFoPT5NgbRzudYu2Ob2FQotoTMzQLvYzz20=; LtpaToken
=/hDbBRFtGu6yFiYpCwijT2XsHyLXVjL0r0wu6rMSvLBQjRfYfU4bfOIw9I5C+RKQPd+KXuIJ1k385frGAbMUPktg88q/xdlkqrALHvF70J2K80BMnPyiNKRhL7aBRdzO9x4l
+tlOZ6odoDjXQXrdE8l160uVuAC6EEjb0vcRsLtGOl/fLQ4sAy68UL8KGKMLvoriYVP3SrNlSyct5yn4aOqCNGCcxZOqPRofPxhaHL4Iy3oetpEpym5
+6NMZk5SsSFe5Or5E8wEmuOwKatoowndPYD6VaRJ6mFnynlouyWr6vW4soPPPW6r4i/amZ7gvu8/Zr/5QkSs=; lcLang=en_us;
 DWRSESSIONID=lWvVZ*2D6t6WS657Kx7cXgy4gkl; JSESSIONID=94FCBF5F9DEB1001A76B217B394E4112
X-Atlassian-Token
nocheck
Origin
http://iasp091x.ia.ro.conti.de:8080
Accept-Encoding
gzip, deflate
Host
iasp091x.ia.ro.conti.de:8080
Accept-Language
en-US,en;q=0.8,ro;q=0.6
User-Agent
Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari
/537.36
Content-Type
application/x-www-form-urlencoded; charset=UTF-8
Accept
*/*
Referer
http://iasp091x.ia.ro.conti.de:8080/issues/?jql=DoD%20%3D%20checkedItem(Integrated)
X-Requested-With
XMLHttpRequest
Connection
keep-alive
Content-Length
69

 

 

@Cristina Abunei,

Thank you but what would help more is if you look at the JIRA logfiles and check any errors that are logged and which happens after you try the JQL.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Jul 10, 2018 in Marketplace Apps

If you’re an Atlassian app developer, you’ll want to know about Atlas Camp!

This September 6-7, hundreds of Atlassian App developers will flock to Barcelona Spain to build skills, discover product roadmaps, meet face-to-face with the Atlassian team, and learn how to extend t...

173 views 0 4
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you