Direkt zum Inhalt

Devbits

Kleine Code-Schnipsel aus unserem Alltag mit Drupal, PHP und DevOps: Problem, Lösung, Code.

21.11.2025 | Henjo Völker

Jira JQL Filter: exclude issues with certain labels, but include issues without labels

If you filter your issues by labels and you exclude a certain label, e.g. by using `AND labels !=yourlabel`, for some reason Jira will also exclude all issues that have no label at all.

AND (labels = EMPTY OR labels != yourlabel)

Issue:

If you filter your issues by labels and you exclude a certain label, e.g. by using `AND labels !=yourlabel`, for some reason Jira will also exclude all issues that have no label at all.

Solution:

Expand your JQL filter logic as shown in the snippet. If you have no further filter logic before the label filter, drop the `AND` operator. You will now get all issues that have other labels than `yourlabel`, including issues without any labels.

13.11.2025 | Henjo Völker

Jira JQL Filter: Issues with a date field value in the next upcoming month

For some Jira dashboard filters it can be useful to list issues with a certain date field (e.g. the duedate if you're planning your work ahead) inside the upcoming (or any future upcoming) month.

AND "[yourDateField]" >= startOfMonth("+1") AND "[yourDateField]" <= endOfMonth("+1")

Issue:

For some Jira dashboard filters it can be useful to list issues with a certain date field (e.g. the duedate if you're planning your work ahead) inside the upcoming (or any future upcoming) month.

Solution:

You can utilize the startOfMonth and endOfMonth operators for this, followed by a number specifying how many months ahead or behind you want to look. ("+1") in the example means next month. Now if you view your filter on any day in May, you will see all issues due in June, and if you look at it in June, you will see everything due in July. You can also use ("-1") to see what would have been due in the past month. Don't forget to exclude closed issues from your filters.