In a filter, how to make sure a custom field doesn't equal another custom field?

Tim Groven

I have two custom fields that are both dates. I am trying to create a filter that will list issues where the dates in the custom fields do not match.

I try:

cf[10087] != cf[10088]

but get the following error:

Error in JQL Query: Expecting either a value, list or function but got 'cf'. You must surround 'cf' in quotation marks to use it as a value. (line 1, character 55)

Is there a way to do what I need?

Thanks,

Tim

Markus Lepper1

Hello Tim,

In Jira's documentation you could find:

A query consists of a field, followed by an operator, followed by a value or function. For example, the following query will find all issues in the "TEST" project:

...

Note that it is not possible to compare two fields.

I've posted a similar kind of question in the forum and did not get a solution: See this thread.

I tried to do a search like "Reporter != Assignee" which does NOT work as well in JQL.

Sorry...I would like to have a solution, too.

BR, Markus