Hello, I'm in the process of creating a custom field in ScriptRunner to translate string values into integers so that they can be sorted from largest to smallest in JQL.
Here's what I have so far:
log.warn("starting")
import com.atlassian.jira.component.ComponentAccessor;
import com.atlassian.jira.ComponentManager;
import com.atlassian.jira.issue.CustomFieldManager;
import com.atlassian.jira.issue.fields.CustomField;
import com.atlassian.jira.issue.IssueManager;
import com.atlassian.jira.issue.Issue;
def issueManager = ComponentAccessor.getIssueManager()
def customFieldManager = ComponentAccessor.getCustomFieldManager()
def cField = customFieldManager.getCustomFieldObject(12230L)
def cFieldValue = issue.getCustomFieldValue(cField) as long
log.warn(cFieldValue.getClass())
return cFieldValue
Despite the fact that I've defined cFieldValue as a long, this custom field still cannot be sorted properly. What am I missing?