JQL (Jira Query Language) is a powerful query language that allows you to search for issues in Jira based on various criteria. Whether you are a Jira beginner or a seasoned user, here are some essential tips and tricks to help you become more efficient and effective with JQL.

‍

Basic Filters

1. Text Search

text ~ "search term"

Use the ~ operator to search for specific keywords or phrases within issue summaries, descriptions, or comments.

2. Issue Key Search

issueKey = ABC-123

Search for issues by their unique issue key. Replace ABC-123 with the actual issue key.

3. Status Search

status = "In Progress"

Use the status field to filter issues based on their current status. Replace "In Progress" with the desired status.

4. Assignee Search

assignee = currentUser()

Find issues assigned to the current user or use a specific username to search for a particular assignee.

5. Project Search

project = "Project Name"

Filter issues by a specific project name. Replace "Project Name" with the desired project.

Advanced Filters

1. Date Range Search

created >= startOfDay(-7d) AND created <= endOfDay()

Search for issues created within the last 7 days. Modify the number and unit (d for days, w for weeks, m for months) as needed.

2. Issue Type Search

issuetype in (Task, Bug, "User Story")

Find issues of specific types by using the issuetype field. Replace the examples with the desired issue types.

3. Label Search

labels = "label1" OR labels = "label2"

Search for issues with specific labels. Use the OR operator to include multiple labels.

4. Priority Search

priority = High ORDER BY created DESC

Filter issues by priority and order them by creation date in descending order. Replace High with the desired priority level.

5. Subtask Search

parent = ABC-123

Find all subtasks of a particular parent issue. Replace ABC-123 with the issue key of the parent.

Additional Tips

• Use parentheses ( ) to group conditions and control operator precedence.
• Utilize functions like startOfDay(), endOfDay(), currentUser(), and more for dynamic searching.
• Use the logical operators AND, OR, and NOT to combine filters.
• Explore additional JQL functions and operators in the Jira documentation.

With these JQL tips and tricks, you can significantly improve your efficiency in searching and managing issues in Jira. Happy querying!

Note: Replace all the example values in the above queries with appropriate values according to your Jira instance.

‍