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; } } }

Set "select type" custom field value based on value of another "select type" custom field?

Pete P_lbwqsx

Using the "Set field value (JMWE app)" post function I need to set the value of a custom field based on the values of another.

Custom Field 1: "Grant Type" (A,B,C)
Custom Field 2: "Team Queue" (1,2,3,4,5)

If "Grant Type" selectedValue = A set "Team Queue" selectedValue to 5
If "Grant Type" selectedValue = B set "Team Queue" selectedValue to 4
If "Grant Type" selectedValue = C set "Team Queue" selectedValue to 2...

What is the proper syntax for this? I am struggling with it...

Accepted answers

Fabian Lim

Hi @Pete P

I believe the "Set field value" post-function has a lot of limitations. Use the "Scripted Groovy" post function instead.

You can follow the instructions here for the scripted groovy post function: https://innovalog.atlassian.net/wiki/spaces/JMWE/pages/139635057/Scripted+Groovy+operation+on+issue

Regards

David Fischer

Hi @Pete P

using JMWE's Set Field Value post-function, you can easily achieve this.

As the "Field to set", select your Team Queue field.

As the Value type, select "Groovy Expression"

As the Value, use a script like:

switch (issue.get("Grant Type")) {
 case "A": return 5;
 case "B": return 4;
 case "C": return 2;
}

This assumes that the Team Queue field is a Number field. Otherwise, you'll need to return a String instead:

switch (issue.get("Grant Type")) {
  case "A": return "5";
  case "B": return "4";
  case "C": return "2";
}

All comments

Fabian Lim

Hi @Pete P

I believe the "Set field value" post-function has a lot of limitations. Use the "Scripted Groovy" post function instead.

You can follow the instructions here for the scripted groovy post function: https://innovalog.atlassian.net/wiki/spaces/JMWE/pages/139635057/Scripted+Groovy+operation+on+issue

Regards

Pete P_lbwqsx

Thanks for advice @Fabian Lim

Pete P_lbwqsx

They are pretty vague on their examples unfortunately

David Fischer

Hi @Pete P

using JMWE's Set Field Value post-function, you can easily achieve this.

As the "Field to set", select your Team Queue field.

As the Value type, select "Groovy Expression"

As the Value, use a script like:

switch (issue.get("Grant Type")) {
 case "A": return 5;
 case "B": return 4;
 case "C": return 2;
}

This assumes that the Team Queue field is a Number field. Otherwise, you'll need to return a String instead:

switch (issue.get("Grant Type")) {
  case "A": return "5";
  case "B": return "4";
  case "C": return "2";
}

Pete P_lbwqsx

Thank you @David Fischer - works as described

Pete P_lbwqsx

@David Fischer - one more question if I may ask.
Above works perfectly for my single select lists.

Do you know syntax to use for determining the "case" value with custom field type "Select List (cascading)" ?

In this field type there is parent option and selected value. If I just use selected value for case it doesn't work, also I tried "parent option - selected value" which also does not work.

David Fischer

Hi @Pete P ,

well, it depends on how you want to treat the parent and child options. Do you have a different Team Queue value for each combination of parent and child values? Or is it based just on the parent value?

If it's based on the combination of parent and child, you can do something like:

switch (issue.get("customfield_10202")?.get(null)?.value) {
  case "Parent A": 
    switch (issue.get("customfield_10202")?.get("1")?.value) {
      case "Child 1": return "A.1"
      case "Child 2": return "A.2"
    }
  case "Parent B": 
    switch (issue.get("customfield_10202")?.get("1")?.value) {
      case "Child 1": return "B.1"
      case "Child 2": return "B.2"
    }
}

If neither the parent nor the child values can contain a comma (","), then you can also use a single switch, knowing that the parent value and child value will be separated with a comma:

switch (issue.getAsString("customfield_10202")) {
  case "Parent A,Child 1": return "A-1"
  case "Parent A,Child 2": return "A-2"
  case "Parent B,Child 1": return "B-1"
  //etc...
}

Welcome!

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

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server

groovy

workflow

jira-misc-workflow-extensions