How to query field using Script Runner

[Cesar Covarrubias]

I am trying to setup a listener using Script Runner to auto transition a field based on the value of a custom field. The plugin provides the following template:

cfValues['SomeCustomField'] == 'Some Value'

I have tried the following:

cfValues['Field Name'] == 'Yes'

But this isn't working. Any suggestions on how to check the value of a custom field for my condition statement?

[Cesar Covarrubias · Accepted solution]

Turns out i was making a noobish mistake. This worked for me:

cfValues['Standard Request']?.getValue() == 'Yes'

I needed to add the getValue method in order to do my comparison.

[JamieA]

The key question as Thomas says is "what kind of field". You can do

log.warn cfValues['Standard Request']

That will give you the class name, from that you can read the javadoc to see how to get the string value or values, or whatever.

[Kathryn Allison]

This is not working for me when using Select List, as opposed to Radio Buttons. Any ideas?

[JamieA]

Can you post what you are using.

cfValues['A Radio Field']?.getValue() == 'Yes'

should work fine.

[Kathryn Allison]

I am using:

cfValues[‘A Select List Field’]?.getValue() == ‘Yes’

[Kathryn Allison]

Any ideas why this wouldn't work for a select list?

[JamieA]

It should work fine. Use an assertion to test as per https://jamieechlin.atlassian.net/wiki/display/GRV/Built-In+Scripts#Built-InScripts-PowerAssertions

[Kathryn Allison]

I guess 'Yes' needed to be written "Yes" or the condition kept failing.

I got this working after reviewing your link. Thanks so much!

[Kathryn Allison]

Is there a parameter I can add to make the condition specific to a project?

[JamieA]

&& issue.projectObject.key == "ABC"

[Kathryn Allison]

I can't seem to get this to work. Tried using an assertion and it returns 404 page

[Kathryn Allison]

issue.projectObject.key != "ABC" && cfValues['Customization Issue']?.getValue() == "Yes"

This script accomplishes what I want it to do when the value = Yes. But, when the custom field = No, it also firing the function, when I don't want it to.

Any ideas?

[Kathryn Allison]

Nevermind. Got it figured out thanks to this thread: https://answers.atlassian.com/questions/70196/how-to-set-complex-validators-in-jira-s-workflow

[Thomas Heidenreich]

What kind of custom field is this?

If it is a checkbox you could use:

cfValues['Field Name'] != null

Hope this helps,
Thomas

[Cesar Covarrubias]

It's a radio button with "Yes" or "No" as options.

[Christophe Leite]

Answer o Yes o No ............. it was an example of the radio button field I have with the values which can be chosen.

[Christophe Leite]

Ok, but how do you get the value ? cfValue['Answer'].value ?

Answer o Yes o No

Because, in Jira, I would like then test cfValue['Answer'].value == 'Yes' in order to fasttrack a transition, but it does not work unfortunately...

[JamieA]

It should be cfValues (plural)

[JamieA]

Use: cfValue['Answer']?.value

Use Admin -> Built-in Scripts -> Condition Tester to make sure that is evaluating to what you expect...

> Ok, but how do you get the value ? cfValue['Answer'].value ?
> Answer o Yes o No

I didn't understand this...

[Christophe Leite]

Did you get an answer for radio button ? I'm still looking for...

Thanks,

Any help appreciated

[JamieA]

The accepted answer is correct for radio buttons.