Filtering in JIRA
When you need to find specific issue/task/combination of tasks in JIRA
Basic filtering
It is possible to create a filter on click
Easy filters for quick view
Not possible to create complex filters with conditions
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
https://www.atlassian.com/blog/jira-software/jql-the-most-flexible-way-to-search-jira-14
https://www.tutorialspoint.com/jira/jira_advanced_search.htm
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