How to write a JQL query in Jira | Jira Software tutorial

In this video, you'll learn how to write a JQL query in Jira using three things: fields, operators, and values. Together, these make a clause. You can have multiple clauses in a query. You can then connect clauses using keywords.

[luckynath]

i have question, iwant only those incident which have open or close, for that there is status field, in status field there is name key and open or close property, how i get that name key value from status fields

[robby]

JQL query sucks big time. It' the worst scripting / searching or whatever language I've ever encountered and I'm talking in over 40 years of coding. It is full of inconsistencies and ambiguities. Been using Jira for 15 years and I still cannot create a functioning query without much gnashing of teeth, and even then it likely doesn't do what I want.