I want to check in an JQL if one custom date field is greater or equal than another custom datefield.
I tried using Script Runner and the Expression issueFunction in dateCompare("", "Urlaubsende >= Urlaubsanfang ")
but i get the error
"Field name: Urlaubsende > not found or not a date or datetime."
other solution attempts than using script runner are welcome
Community moderators have prevented the ability to post new answers.
It seems that <= and >= are not allowed.
Try use < or > only (https://jamieechlin.atlassian.net/wiki/pages/viewpage.action?pageId=57999378#ScriptedJQLFunctions-dateCompare(Subquery,datecomparisonexpression))
Oh, I got it, Field name: Urlaubsende > not found or not a date or datetime.
I think the '>=' can't be used. In your expression, the operator choosen is '='. '>' is a part of Urlaubsende!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Comparing two date fields in JQL is not supported: https://jira.atlassian.com/browse/JRA-20727
Unfortunately, it is not even in Atlassian's roadmap.
There's a workaround for JIRA Server through the usage of Script Runner.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Damien,
im pretty sure its not a typo, "Urlaubsende is not EMPTY AND Urlaubsanfang is not EMPTY" works.
Is that what you meant?
I also removed any spaces, no luck
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
i tried adding +1w to both dates but that wont convert the customfields to datetime
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Community moderators have prevented the ability to post new answers.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.