Is there a definitive list of JQL or IQL commands anywhere?

[Jason Selby]

I am trying to use complex queries to link assets up to Employees in Insight and cannot find the correct commands anywhere on the support site or the internet to be exact, if anyone has this list it would be extremely useful. The documentation is limited in my opinion. I believe there is so much more you can do but no examples of how best to use Insight

[Florian PEREZ · Accepted solution]

Hello, 

I personally mostly refer on these 2 links : 

https://support.atlassian.com/jira-service-management-cloud/docs/advanced-search-reference-jql-functions/

https://support.atlassian.com/jira-service-management-cloud/docs/advanced-search-reference-jql-fields/

These are litterally lifesavers. 

Hope this help 

[Jason Selby]

This is splendid, any IQL out there?

[Florian PEREZ]

These Two other links should get most most of the information : 

https://support.atlassian.com/jira-service-management-cloud/docs/use-insight-query-language-iql/ 

https://support.atlassian.com/jira-service-management-cloud/docs/insight-jql-functions/ 

Hope this help 

[Florian PEREZ]

Hey @Jason Selby Juste a friendly reminder, If this fit your needs don't hesitate to mark this as accepted answer so the topic can be consider as close and people know the reolution ! 

Many thanks !  

[Florian PEREZ]

One more thing I heard about a book about JQL by @BogdanGorka

It's not release yet but it does have plenty of JQL for many use cases. 

Another good ressource is this bible of Rachel Wright :  Jira Strategy admin workbook. One part give some nice JQL for specifics case. 

[G subramanyam]

Hi @Jason Selby welcome to the Atlassian community.

Their are no specific or detailed JQL list available on Atlassian sites nor in Google. You might need to start with @Florian PEREZ provided links and experiment for self.