Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How can a JQL query be used to find ≠ values on a single issue? Edited

I am needing to create a query to identify when the Version Name and the associated Release date on a single issue are not equal. 

Our previous process required users to enter the release date as the Version Name (dont ask...lol) and we are now transitioning to instead use the associated Release date field. Until we can ensure adherence to entering the Release date, we are asking users to put the same date in both fields. To monitor this process, we are currently needing to export the data and look for the mismatches in excel; however are hoping someone has a way to look for these mismatches directly in the query and can save us this additional step.

The question is can JQL be used to look for (Release date ≠ Version Name)

2 answers

0 votes
Nir Haimov Community Leader Feb 02, 2021

Hi @alexander_dvorkin 

Use this for version:

fixVersion not in (1.0.0, 1.1.0, 2.2.0)

And use this for dates:

fixVersion not in releaseDate("on 2020-12-31")

You can google for "jql release date" for more dates example 

Hi @alexander_dvorkin ,

out of the box, this is not possible via JQL. You can't compare values in a way SQL supports. But if you have Scriptrunner installed, there might be a solution: issueFieldMatch

It takes the following parameters:

  1. subquery
  2. fieldname
  3. regexp (for comaprison)


Usage: issueFunction in issueFieldMatch("project = JRA", "description", "ABC\\d{4}")

Hope this helps. There is also SQL for Jira, which might be worth looking at.

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you