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

Cristina_Abunei
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.
July 11, 2016

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

0 votes
Cristina_Abunei
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.
July 11, 2016

@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

 

 

Yves Riel [Okapya]
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
July 11, 2016

@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.

0 votes
Yves Riel [Okapya]
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
July 11, 2016

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events