I have two custom date fields of Date Picker type namely Planned Delivery Date" and "Original Planned Date". I need to compare them using say > or < or != in a jira filter query but unable to achieve. Using scripted query:- issuefunction in datecompare ("","Planned Delivery Date> Original Planned Date") gives error response. please correct me on how to achieve this
Many thansk for responding me.
Actually i tried out this initially but got typical jql error that these are not date fields and no further suggestions despite auto-complete on. Then since i have script runner plugin installed i tried out the query issuefunction in date compare (......) but it only gave me options to compare default jira date fields like resolutiondate and duedate,etc
Try to do it with their ID's?
I'm doing something quite similar (in jira 4.2, both are date custom fields)
("Start date" <= now() and "End date" >="-1d" )
So all issues appear that are with their dates fixed to today.
Does this help?
Are they date or date/time CF's?
Once again thanks for quick response.
Actually as i mentioned i have to compare two custom date fieldss which i'm not allowed to do despite using script runner plugin. Script runner only helps to compare two date fields against each other like resolutiondate>duedate using issuefunction in date compare query as i mentioned. In default jira you cannot even compare two defauilt jira date fields because utmost you can compare a dcefault jira date field with functions like currentlogin(),now(),etc. So please let me know how i can compare two custoim date fields in jql.
I'm sorry to say, but I don't know how I can help you further. :s
Search the Internet for help?
Add tags scritp-runner and issue-filter to you question, to get more help?
Good luck with it.
(When I saw your own response was each time a few minutes ago, I come check the page often)
Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...
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
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot