nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to get value of a JIRA custom field using the field id using groovy

Nishant Kansal

Hello,

I am new to groovy and looking for help for the following:

From my JIRA administrator, I got the following id's having database related information.

Database Server Type: ID=10513

Database Server Name: ID=12906

Database Name: ID=12911

Database Username: ID=12907

Database Password: ID=12908

My requirement: I have to develop a groovy script that should fetch the corresponding values based upon the ID's above and next, login into JIRA database using those values. I found groovy has sql class that allows connection to database. For that, I require values from the above ID's.

Please help.

Thanks,

Nishant

Accepted answers

All comments

Vasiliy Zverev

Do you need to do this with external tool (not JIRA) or from JIRA itself?

Groovy is user for internal scripts.

For external tool I wood recommend you to start with JIRA REST API: https://developer.atlassian.com/jiradev/jira-apis/jira-rest-apis/jira-rest-api-tutorials

Nishant Kansal

Thanks Vasiliy for your guidance.

I have to execute the script from JIRA itself as a post function. Further, with the help of different posts, I have developed the below script. All I am trying is to find the field value against the field id:10513.

---------------------------------------------------------------------------------------------------------------------------------------

import com.atlassian.jira.ComponentManager
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.IssueManager
import com.atlassian.jira.issue.Issue
import com.atlassian.jira.issue.CustomFieldManager
import com.atlassian.jira.issue.fields.CustomField

void customFieldValues (String customFieldId) {

// gets a reference to the IssueManager and CustomFieldManager manager classes
final CustomFieldManager customFieldManager = ComponentAccessor.getCustomFieldManager()

// gets a reference to the desired custom field
final CustomField customField = customFieldManager.getCustomFieldObject("customFieldId")

// retrieves the custom field value object from the issue

final Object customFieldValue = getCustomFieldValue("customField")
// prints value to console
System.out.println("Custom field value: " + customFieldValue)
}
customFieldValues("10513")

---------------------------------------------------------------------------------------------------------------------------------------

However, it is giving below error:

groovy.lang.MissingMethodException: No signature of method: org.codehaus.groovy.jsr223.GroovyScriptEngineImpl.getCustomFieldValue() is applicable for argument types: (java.lang.String) values: [customField] at Script691.sumCustomFieldValues(Script691.groovy:20) at Script691.run(Script691.groovy:24)

Could you please help me here?

Thanks,

Nishant

Aleks Yenin (Polontech)

Get CustomField value:

import com.atlassian.jira.component.ComponentAccessor;
import com.atlassian.jira.issue.CustomFieldManager;
import com.atlassian.jira.issue.Issue;
import com.atlassian.jira.issue.fields.CustomField;

def issue = ComponentAccessor.getIssueManager().getIssueByCurrentKey("MFP-10");
def customField =  ComponentAccessor.getCustomFieldManager().getCustomFieldObject(10301L);//customfield id
if(customField != null) {
	issue.getCustomFieldValue(customField);
}

Note: You must have Issue to get value from, because Customfield does not save data by itself.

Aleks Yenin (Polontech)

There is no such a function getCustomFieldValue in your code. There can be

issue.getCustomFieldValue(customFieldObject);

Also do not use double qoutes here

customFieldManager.getCustomFieldObject("customFieldId")

because you it will be transformed to String. Use it without scopes:

customFieldManager.getCustomFieldObject(customFieldId)

Nishant Kansal

Thanks Aleks for all the tips. I tried your your provided script as below with currentkey and customfieldid per my JIRA set-up. However, it is giving "Null" response. Any help on this, please?

--------------------------------------------------------------------------------------------------------------------------

import com.atlassian.jira.component.ComponentAccessor;

import com.atlassian.jira.issue.CustomFieldManager;

import com.atlassian.jira.issue.Issue;

import com.atlassian.jira.issue.fields.CustomField;

def issue = ComponentAccessor.getIssueManager().getIssueByCurrentKey("MFP-10");

def customField =  ComponentAccessor.getCustomFieldManager().getCustomFieldObject(10301L);//customfield id

if(customField != null) {

        issue.getCustomFieldValue(customField);

---------------------------------------------------------------------------------------------------------------------------

Thanks,

Nishant

Mohit Jayesh Patel

Hi Aleks,

I tried your code and it worked for me, however what I am trying to do is also automatically fetch the current issue key and use the custom field value in a sql query. I am getting the custom field value if I hardcode my issue key. The sql too isnt functioning. Please point out where I am going wrong. I get null returned for this.

Following is my code:

import com.atlassian.jira.component.ComponentAccessor;
import com.atlassian.jira.issue.CustomFieldManager;
import com.atlassian.jira.issue.Issue;
import com.atlassian.jira.issue.fields.CustomField;
import com.atlassian.jira.issue.IssueManager
import groovy.sql.Sql
import java.sql.Driver

def issue = ComponentAccessor.getIssueManager().getIssueByCurrentKey("TR-24");
def customField = ComponentAccessor.getCustomFieldManager().getCustomFieldObject(11495L);//customfield id

def bugid = issue.getCustomFieldValue(customField);

def driver = Class.forName('com.mysql.jdbc.Driver').newInstance() as Driver

def props = new Properties()
props.setProperty("user", "rxy")
props.setProperty("password", "rxy")

def conn = driver.connect("jdbc:mysql://localhost:3306/bug", props)
def sql = new Sql(conn)

try {
sql.eachRow("select p.realname from bugs.bugs b join bugs.profiles p on b.qa_contact=p.userid where bug_id = ${bugid}") {
log.debug(it)
}
} finally {
sql.close()
conn.close()
}

Tushar_ki71l7

Dear All,

I am looking for the script which will get the external values in the Jira custom field.

Can someone help me on this scripting?

Your help will be much appreciable.

Thanks,

aditya mandlekar

How can we convert the below line of code 

def issue = ComponentAccessor.getIssueManager().getIssueByCurrentKey("MFP-10");

to make it more generic in a way where it can work for any Key

Ahsan_l44t9g

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.fields.screen.FieldScreenFactory
import com.atlassian.jira.issue.fields.screen.FieldScreenManager
import com.atlassian.jira.issue.fields.screen.FieldScreenSchemeManager
import com.atlassian.jira.web.action.admin.issuefields.screens.ViewFieldScreens
import com.atlassian.jira.workflow.WorkflowManager

def sb = new StringBuffer()
def issueManager = ComponentAccessor.getIssueManager()
def customFieldManager = ComponentAccessor.getCustomFieldManager()
def cField = customFieldManager.getCustomFieldObject("customfield_id")

sb.append("${cField}<br/>\n")

return sb.toString()

Steve Johnson_6wf5c6

This is the solution that worked for me

import com.opensymphony.workflow.InvalidInputException
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.Issue
import com.atlassian.jira.issue.IssueManager
import com.atlassian.jira.issue.CustomFieldManager
import com.atlassian.jira.issue.fields.CustomField

// Filed id : customfield_16306 --> This is field ID for Impact Score.
def cf = getFieldById("customfield_16306");
//int cFieldValue = (int)(cf.getValue())
def cFieldValue = (int)(cf.getValue() ? cf.getValue() : 0)

if (cFieldValue >= 1 && cFieldValue <= 100 )
{
cf.clearError()
}
else if (cFieldValue < 1 || cFieldValue > 100 )
{
//below Command displays Error and but allows the user to submit the change. If you are enabling below comment setError
//cf.setHelpText("Impact Score provided should be between 1 - 100. Please correct Impact Score to an acceptable range. Current score : "+ cFieldValue)

cf.setError("Impact Score provided should be between 1 - 100. Please correct Impact Score to an acceptable range. Current score : "+ cFieldValue)

}
else
{
cf.setError("Impact Score provided should be between 1 - 100. Please correct Impact Score to an acceptable range. Current score : (Blank) ")
}

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-core