nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to use the value from date field in filter query

Mark McDonnell

I would like to use a date field, either the system "duedate" or my own custom date field, as a value for comparison in a filter query, for example to see issues where a particular status transition was made before a specific date. I've tried lots of combinations such as;

project = XY AND status changed from "Start" to "In progress" before duedate

But the query will only accept a specific date or a relative date (e.g. "-5d") after the term "before". Is there some way to use the value from a date field like this?

Thanks

Accepted answers

All comments

Shawn Masters

https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-operators-reference-764478341.html

Find all issues with 4 or more votes:
```
votes >= 4
```
Find all issues due on or after 31/12/2008:
```
duedate >= "2008/12/31"
```
Find all issues created in the last five days:
```
created >= "-5d"
```

Mark McDonnell

Thanks Shawn.

I know I can use absolute dates or relative dates in my query as a comparison to a date field as per your examples. What I'm looking to do is to use the value from a date field as a comparison to another non-absolute factor, such as another date field.

For example;

Comparison between due date and another user defined date field:

duedate <= MyDateField

Comparison between a user defined date field and the date a status was transitioned:

status changed from "Start" to "In progress" before duedate

status changed from "Start" to "In progress" < duedate

Shawn Masters

I haven't run across a way to do quite that, especially that first example.

#2 could look something like ...

status was in "Start" And status in "In Progress" And duedate <= "Insert Date"

Robert de Groot

Unfortunately there is no way to compare two fields in Jira.

The only way I can think of to accomplish this would be to build your own plugin to create a custom jql function that you can pass a custom_field_id to and returns a date.

example of resulting JQL:

status changed from "Start" to "In progress" before getCustomFieldValue(customfield_123456)

Shawn Masters

Found an Addon that might help you with this.... Abacus for Jira Cloud. It allows you to create Formula based on Jira fields.

Mark McDonnell

Ok thanks. Shame that you can compare either field to an absolute date but not to each other.

Mark McDonnell

Thanks Shawn, that only seems to be available for JIRA cloud though and I'm on server unfortunately.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server