I have a select list field which consist of a values yyyymm e.g 201308 or 201309.
Is it possible to have a JQL function which returns me the value yyyymm based on current date and then I can compare this returned value to the custom select list field in JQL search?
thanks in advance
I would suggest using a calculated field - https://jamieechlin.atlassian.net/wiki/display/GRV/Scripted+Fields
Be sure to select the Date Time Range picker as the searcher.
This field would populate from 201308 to August 1, 2013 (as a date)
You could then use JQL to do very powerful searches:
customfield > startOfDay()
customField < -3d
ORDER BY customField
see https://confluence.atlassian.com/display/JIRA/Advanced+Searching#AdvancedSearching-Created for an example of date based searching.
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG