JQL query for Labels and Schdueled ReleaseDate

I need a query for pull data from JIRA based on lable created date and Schduled releaseed date feild

I am using useing JIRA 6.4

 

Thanks in Advance

1 comment

Rachel Wright Community Champion Jun 09, 2017

 

Hi Sunil,

I checked the labels table in the database, and the label creation date isn't there.  The date the label was added to an issue might be accessible, as part of the change history, but you'd need to query the database to get that.  I can't tell from your question if you're looking for a db query or JQL (JIRA Query Language), but I'll assume JQL for now.

Instead of label date, here's how you'd query for a label and for a value in a custom field called "Scheduled Release Date":

labels = maintenance and "Scheduled Release Date" >= "2017-01-01"

You can also do things like :

labels in (maintenance, upgrade)
"Scheduled Release Date" >= startOfYear()

More on all the cool things you can do with JQL is found here: https://confluence.atlassian.com/jirasoftwareserver071/advanced-searching-800707146.html  (For your version, 6.4, see: https://confluence.atlassian.com/jira064/advanced-searching-720416661.html)

One more thing:  When doing a "not" search with the label field, also consider issues with no label.  For example, to be inclusive, the query:  

labels = maintenance

should instead be:

labels != maintenance and labels is not empty

Hope this helps,

Rachel Wright

Thanks Rachel it worked

Comment

Log in or Sign up to comment
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Aug 06, 2018 in Jira Service Desk

A is for Activate: Share your top Jira Service Desk onboarding tips for new users!

Hi, everyone! Molly here from the Jira Service Desk Product Marketing Team :).  In the spirit of this month's  august-challenge, we're sourcing stories of Jira Service Desk activation fro...

580 views 25 15
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you