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

[Cristina_Abunei]

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

[Cristina_Abunei]

@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
HeadersPostResponseHTML 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
HeadersPostResponse 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_]

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

[Yves Riel _Okapya_]

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