Filtering in JIRA

• When you need to find specific issue/task/combination of tasks in JIRA

Open

Basic filtering

• It is possible to create a filter on click

• Easy filters for quick view

• Not possible to create complex filters with conditions

Open

Advanced filtering (JQL)

• For more complex queries

• It is easy to find exactly what you want

Examples

Here are specific exaples, how to filter in JIRA. There plenty of ways, what would be good to filter. Mostly it is used “project“, “issuetype”, “status”, “reporter”, “sprint“, etc.)

I want to see all bugs on my project Michelin France (all time)

• project = "Consulting - Michelin France" AND issuetype = Bug

I want to see all sub-tasks with prefix Defect on project Michelin (all time)

• project = "Consulting - Michelin France" AND issuetype = Sub-task AND summary ~ "Defect*"

I want to see sub-tasks with prefix Defect on project Michelin only for specific sprint

• project = "Consulting - Michelin France" AND issuetype = Sub-task AND summary ~ "Defect*" AND Sprint = "Feature Sprint 2"

I want to see stories in status Ready for Review (DEV) (status, when I need to start testing of the story)

• project = "Consulting - Michelin France" AND status = "Ready for Review (DEV)"

I want to see stories in status Ready for Review (QA) (status, when client needs to review the story, without sub-tasks)

• project = "Consulting - Michelin France" AND status = "Ready for Review (QA)" AND type != Sub-task

Tutorial Links

• JQL: the most flexible way to search Jira

• Searching for what you need in Jira using JQL

• The Jira JQL Advanced Guide: How to Search Jira Issues Like a Pro

• JIRA - Advanced Search

List of Keywords

• AND − ex - status = open AND priority = urgent And assignee = Ashish.

• OR − ex – duedate < now() or duedate is empty.

• NOT − ex – not assignee = Ashish .

• EMPTY − ex - affectedVersion is empty / affectedVersion = empty.

• NULL − ex – assignee is null.

• ORDER BY − ex – duedate = empty order by created, priority desc.

List of Operators

• Equals: =

• Not Equals: !=

• Greater Than: >

• Less Than: <

• Greater Than Equals: =>

• Less than equals: =<

• IN

• NOT IN

• CONTAINS: ~

• Does Not contain: ! ~

• IS

• IS NOT

• WAS

• WAS IN

• WAS NOT IN

• WAS NOT

• CHANGED

How to save filter

• Click on Save as, than fill name and then click on Submit

• Now is filter visible only for you - if you want to share with someone, or use it on dashboard, you need to set permission

How to set permissions to your filter

• Possible to send to someone

• Possible to use in shared dashboard

• Click on Details and then on edit permissions

• Now is needed to set groups/users/setting

• After choose value in “Access“ part, do not forget to click on “Add“ button

• Be aware of when you create a dashboard, which client wants to see, you need to set access for him too