In our setup, we have two calculated Date fields for which we have a strong need to compare.
I have tried this as follows: issuefunction in datecompare("","DateField1 < DateField2") which returns an error
Field name: DateField1 not found or not a date or datetime.
However, something like this works: DateField1 < now()
Is there some workaround for this? I have found that comparing two calculated dates seems not to work somehow, but I can't imagine that noone has found a solution for this
Community moderators have prevented the ability to post new answers.
Somehow I can't seem to get "expression" to work... (see my comment above).
@Jamie Echlin [Adaptavist]: Where do I find my support number to create a support request?
Hi Christian,
I can help you with finding your SEN for JIRA. Here's an article that covers most Atlassian applications including JIRA:
https://confluence.atlassian.com/support/finding-your-support-entitlement-number-229840018.html
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This only covers SEN for Atlassian applications and some others, but it doesn't help me regarding Adaptavist SEN. I assume I have to have sysadmin privileges to find it in the Scriptrunner configuration page?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Christian,
You should have admin privileges to be able to get to the Admin console --> Add-ons --> Manage Add-ons then you can find the Adaptavist ScriptRunner Add-on and then you can find the License SEN.
Failing that, please raise the issue without one and ensure we know your company name and we'll look it up ourselves.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
SQL for JIRA supports a lot of auxiliar functions to work with JIRA data, so you can compare dates to create your own custom JQL functions on the fly.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can you try using the expression function which can do the same thing, although the rules around the field names are slightly different.
If you have a commercial version please feel free to create a support request: https://productsupport.adaptavist.com/servicedesk/customer/portal/2
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jamie, thanks for your reply.
We are using a commercial version, but I don't have the SEN at hand. I have tried expression, problem seems to be that the field I'm using has spaces in the name. If I don't escape it, the field isn't found. If I use \"My Field Name\" to escape it, I get the error "Error occurred communicating with the server. Please reload the page and try again."
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What about a third calculated field which gives you the diff itself (or what ever you try to report), than you can query that one!
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.