Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

get the value of an Elements connect field in Scriptrunner scripted field

I want to create a scripted field that has its value set based on the contents of a elements connect field.  So far I have been working in the scriptrunner console just trying to get the value of the field and it keeps returning null.  The Elements connect field is a snapshot field that reads an Active directory value.  I have verified the value is set on the field so it isn't null.  

Here is the code I have so far.

import com.atlassian.jira.component.ComponentAccessor

def pluginAccessor = ComponentAccessor.getPluginAccessor();
def plugin = pluginAccessor.getPlugin("com.valiantys.jira.plugins.SQLFeed");
def serviceClass = plugin.getClassLoader().loadClass("com.valiantys.nfeed.api.IFieldDisplayService");

def fieldDisplayService = ComponentAccessor.getOSGiComponentInstanceOfType(serviceClass);

def issueKey = "Issuekey-123458";
def customFieldId = "customfield_12633";

String displayValue = "";
Object displayResult = fieldDisplayService.getDisplayResult(issueKey, customFieldId);
if (displayResult != null) {
displayValue = displayResult.getDisplay();
}
return displayValue;

 Anybody have an idea how I can get this to work.  The long term goal of this field will be to compare the approvers title to a list of titles we use to stop the approval process.  We are currently using a regular expression in several automation's to compare the titles and I want to consolidate where we are doing this process to one location so when a persons title change we don't have to update multiple automation condition checks.

3 answers

Hi @Dan Wolff

I'm Nicolas from Elements, vendor of Elements Connect.

If you get a "null" result with this piece of code, that means there are 3 possible explanations:
- "customfield_12633" is not a valid reference
- "Issuekey-123458" is not a valid issue key
- field is empty in the given issue

Here is an example with a Scripted Field:

2020-08-05 10_25_16-Window.png

Can you please try again by checking all these points?

If you still have issues, please open a support ticket from this portal: https://support.elements-apps.com/portal

Thank you.

Kind regards,
Nicolas.

I changed the issue key and the custom field id in the script that I posted, but I verified that I have valid information.  

I displayed the field on the edit form and it has a value

I created the scripted field using your example and changing to match my environment and it still returns null.  Also tried using the read field key method same result.  I will open a ticket with your support desk.  

 

Thanks

0 votes
Muhammad Ramzan Community Leader Sep 23, 2020

I am also getting null by using your code, everything is correct issue id , field id.

 

I am surprised for one field its returning value

For one drop down field its returning all values not the selected one

 

for all other fields its returning null

Hi,

with your function from the docs you will get the display value. Have you configured your display view? You can try it in the Field Configuration.

Have you tried to get the key value instead of the display value?

Under Read Field Key:

https://doc.elements-apps.com/elements-connect/latest/api-guide/java-api/scriptrunner-use-elements-connect-api-in-a-script

For everyone who wants to get current value on a Screen like in a transition where you just changed the value and want to react on this change with a Behaviour then you must use a more complicated way:

String value = (String) getFieldById(customfieldId).getFormValue();
if(value != null && value != ""){
def jsonSlurper = new JsonSlurper()
def object = jsonSlurper.parseText(value)
assert object instanceof Map
assert object.inputValues instanceof List
if(object.inputValues){
return object.inputValues.toList();
} else {
return [""];
}
} else {
return [""];
}
 
Like Nicolas Esteves likes this

Hi,

I forgot its now in the docs of Elemenst Connect but only for the new version (6.x). For the update from version 5.x to 6.x i created a function to secure all scripts are functional before and after.

String[] elements_connect(def s){
String e = s as String;
if(e != null && e.length() > 0){
if(e.startsWith("{")){
def jsonSlurper = new JsonSlurper();
def json = jsonSlurper.parseText(e);
String[] connectFieldKeys = (String[]) json["inputValues"];
return connectFieldKeys;
} else if(e.startsWith("[")){
String[] connectFieldKeys = s as String[];
return connectFieldKeys;
} else {
return null;
}
} else {
return null;
}
}
Like Nicolas Esteves likes this

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira

Admins, notify your Jira instance of system-wide changes with the new admin announcement banner

Hi All! We’re excited to share the launch of an announcement banner that lets Jira site administrators communicate directly to their users across their  Jira Cloud instance.  ...

481 views 16 17
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you