Is there a book or reference material about writing complex JQL?

[GREG DORNOFF]

I have a basic understanding of JQL and am looking to learn more to write very complex JQL.  

[Don Swatman · Accepted solution]

I'm not sure about books - do people still write them? However there is a wealth of resources on the web. As in so many things, Google is your friend.
But as a starter, here's a link to a blog from the community.

https://www.atlassian.com/blog/jira-software/jql-the-most-flexible-way-to-search-jira-14

[GREG DORNOFF]

Ha ... books???  Google does a good job but I'm looking for any source of information that tells me if JQL can reference an array, lookup table or anything similar versus listing out all values in a JQL statement.  Any suggestions?

[Don Swatman]

The way I learnt to use JQL was to learn the basics, then google any specific problems I needed solving. Then try, try and try again.

My experience of JQL is that there are many limits as it's a basic query, not a programming language. It seems to be pretty much limited to the fields within your Jira instance which excludes array lookups. You can use x IN y, where the first can be array type or ordinary objects, such as labels or fixVersion. e.g. fixVersion in ("1.1", "1.2"). But I don't think you can select individual items (something like fixVersion[1])

Also it slows down with more complex queries and you have to tune the order of requests.

There are also third party add-ons such as ScriptRunner by Adaptavist. These give a lot more commands to play with which might support your needs. But ...google

Sorry I can't be much more help.

[Joshua Sneed Contegix]

Hi Greg,

Start here and rabbit hole every link on every page. Cheers!