REST API query with bugs that meet some criteria as well as have pull requests merged

Question

Hi,

I am new to using JIRA Rest APIs and I am using a JQL to find all bugs that meet a certain criteria and have pull requests merged. When I use the JQL with development[pullrequests].merged > 0 I see that the query has an Exclamanation mark i.e. error but returns data with the results I want. However if I use the same via a POST in rest API no data is returned. When I try to look at the error that shows up on the Exclamation it seems to suggest a something like Query Line 1: Character 1 :

with info --> ..elopment^pullrequests].merged > 0.

To me it seems like the box bracket needs to be escaped and I tried that but it did not work.

Alternatively is there a way to POST/GET using a JQL with development[pullrequests] via REST API ? my method does not yield any data and has the above errors.

thanks for your help

Attached is the screenshot of the error

unknown · Answer

Yes the query works and returns results on the JIRA GUI even though it has the error show up.

If the GUI is complaining about a syntax error, but the actual JQL works and produces the correct result, then my guess is that either you're running a version of Jira Server before v8, when support for the ability to use JQL to lookup development fields was added (I think), or, your integration with your dev tools is a bit broken.

You might have to look deeper at how the integration is configured. There is this article on fixing a permission issue with the development field, but the error shown on the GUI would be different.

That's about it, as I can't recall any other time I've heard of the issue you describe. Maybe raise a support request with Atlassian before support for Server ends.

Have fun.

Ajay C_dvvi9h · Answer

@[deleted]thanks for your response. Yes the query works and returns results on the JIRA GUI even though it has the error show up.

I have blacked out the project details in the above screen capture.  If I run the same query without the Development[pullrequests].merged > 0 condition the query is fine. Would it be a permission issue with the Development field (?) or similar others. 
I was able to get data via the API and seems like I had it incorrect and now the problem is trivial. however the query though it returns results seems to suggest it is an erroneous query.

unknown · Answer

Hello @Ajay C

When using Jira's GUI, in the Issues search section, are you able to execute a plain JQL search for just:

development[pullrequests].merged > 0

If that works without any error being shown in the syntax, then maybe something in the query before that section is at fault. You've obfuscated that part of the query in your screen grab, so there's no way for anyone to know what your full JQL query is.

With regards using the REST API, it can't 'workaround' any problem in your JQL as it's bound by the same rules at the GUI interface.