Join the community to find out what other Atlassian users are discussing, debating and creating.
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
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
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events