Jira Query Language (JQL) is a text-based query language used to extract specific data from the Jira database. Jira is a swamp of tickets that can weigh you down in the mud of ambiguity, but JQL can help you navigate once you know the syntax. With JQL, you can create structured queries to retrieve the desired issues based on various criteria.<\/p>\n\n\n\n
project = \"My Project\"<\/code><\/div><\/li>\n<\/ul>\n<\/li>\n\n\n\n- Assignee Query<\/strong>:\n
\n- To retrieve issues assigned to the currently logged-in user:
assignee = currentUser()<\/code><\/div><\/li>\n<\/ul>\n<\/li>\n\n\n\n- Status Query<\/strong>:\n
\n- To get issues with the status \u201cIn Progress\u201d:
status = \"In Progress\"<\/code><\/div><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\nExamples of More Complex JQL Queries:<\/h2>\n\n\n\n\n- Complex User-Related Query<\/strong><\/strong>
- To retrieve child issues from multiple parent links (e.g., parent links with keys EX-000, EX-001, EX-002, EX-003):
Parent Link\" IN (EX-000, EX-001, EX-002, EX-003)<\/code><\/div>This query will return all child issues associated with the specified parent links.<\/div><\/li><\/ul><\/li>\n\n\n\n- Child Issues Query<\/strong>:
- To get all child issues below a specific epic (e.g., epic key INIT-00) regardless of their hierarchy level: issue in linkedIssues(INIT-00, “is Epic of”) <\/div>This query ensures you retrieve all child issues, even if nested within other epics or stories.<\/div><\/li><\/ul><\/li>\n\n\n\n
- Complex User-Related Query<\/strong><\/strong>
- To find all issues in the \u201cTEST\u201d project where the assignee is the currently logged-in user: project = “TEST” AND assignee = currentUser()<\/div>This query combines the project field, the EQUALS operator, the value \u201cTEST,\u201d the AND keyword, and the
currentUser()<\/code> function.<\/div><\/li><\/ul><\/li>\n<\/ol>\n\n\n\nUsing Atlassian Intelligence (AI) for JQL:<\/h2>\n\n\n\n
Atlassian Intelligence (AI) is a virtual teammate integrated into Jira Cloud products. It translates your natural language queries into JQL code, making it easier to search for issues. Here\u2019s how to use it:<\/p>\n\n\n\n
\n- Go to the issue navigator in your Jira project.<\/li>\n\n\n\n
- Select the AI option next to the search bar.<\/li>\n\n\n\n
- Type your query in simple language (e.g., \u201cEpics labelled XYZ\u201d).<\/li>\n\n\n\n
- Click \u201cGo\u201d to have AI translate it into JQL.<\/li>\n<\/ol>\n\n\n\n
AI works best when:<\/p>\n\n\n\n
\n- You\u2019re querying using issue fields available in your Jira project.<\/li>\n\n\n\n
- The query has specific fields and values to narrow down your search.<\/li>\n<\/ul>\n\n\n\n
Using Copilot for Generating JQL:<\/h2>\n\n\n\n
Copilot is a great tool for generating scripts using languages like JQL. To use it, all you need to do is ask for what you need in plain English. It’s easy to get started with any AI, and you’ll learn as you go. Don’t be afraid, as you really can’t mess anything up.
Sample Prompt:<\/strong><\/p>\n\n\n\nwrite me a jql script for jira cloud to find bug tickets created on 2024-04-19 with the text \"file type\" in project \"project-x\" ordered by date created<\/code><\/div>\n\n\n\nOutput<\/strong>:<\/p>\n\n\n\nproject = \"project-x\" AND issuetype = bug AND created >= 2024-04-19 AND created <= 2024-04-19 AND text ~ \"file type\" ORDER BY created ASC<\/code><\/div>\n\n\n\nTo execute the JQL query in Jira Cloud, follow these steps:<\/p>\n\n\n\n
To execute the JQL query in Jira Cloud, follow these steps:<\/h2>\n\n\n\n\n- Log in to your Jira Cloud account<\/strong>: Open your web browser and navigate to your Jira Cloud instance. Log in using your credentials.
<\/li>\n\n\n\n- Navigate to the Issue Search page<\/strong>:\n
\n- Click on the \u201cSearch\u201d icon (usually represented by a magnifying glass) in the top navigation bar.<\/li>\n\n\n\n
- Select \u201cAdvanced search\u201d from the dropdown menu.
<\/li>\n<\/ul>\n<\/li>\n\n\n\n - Enter the JQL query<\/strong>:\n
\n- In the \u201cAdvanced search\u201d page, you\u2019ll see a text box where you can enter your JQL query.<\/li>\n\n\n\n
- Copy and paste the following query into that box:
project = \"project-x\" AND issuetype = bug AND created >= 2024-04-19 AND created <= 2024-04-19 AND text ~ \"file type\" ORDER BY created ASC <\/code>Replace\u00a0\"project-x\"<\/code><\/span>\u00a0with the actual name of your project.
<\/li>\n<\/ul>\n<\/li>\n\n\n\n- Run the search<\/strong>:\n
\n- Click the \u201cSearch\u201d button to execute the query.<\/li>\n\n\n\n
- Jira will display the search results based on the criteria specified in your query.
<\/li>\n<\/ul>\n<\/li>\n\n\n\n - Review the results<\/strong>:\n
\n- You\u2019ll see a list of bug tickets that match your search criteria.<\/li>\n\n\n\n
- The results will be ordered by their creation date in ascending order.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n
Helpful Resources<\/h2>\n\n\n\n\n- https:\/\/community.atlassian.com\/t5\/Jira-Software-questions\/how-do-i-write-a-jql-query-to-search-bugs-created-in-last-2\/qaq-p\/1804120<\/a><\/li>\n\n\n\n
- https:\/\/community.atlassian.com\/t5\/Jira-Software-questions\/JQL-to-find-tickets-created-quot-yesterday-quot-last-working-day\/qaq-p\/1782461<\/a><\/li>\n\n\n\n
- https:<\/a>\/<\/a>\/stackoverflow.com\/questions\/8362323\/how-do-i-query-jira-to-search-for-all-issues-that-have-been-resolved-within-a-le<\/a><\/li>\n\n\n\n
- https:\/\/community.atlassian.com\/t5\/App-Central\/How-to-<\/a>filter<\/a>-issues-by-dates\/ba-p\/1706097<\/a><\/li>\n\n\n\n
- https:\/\/community.atlassian.com\/t5\/Jira-questions\/Jira<\/a>–<\/a>filter-for-Business-days\/qaq-p\/1079012<\/a><\/li>\n\n\n\n
- https:\/\/support.atlassian.com\/jira-software-cloud\/docs<\/a>\/<\/a>save-your-search-as-a-filter\/<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"