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

Using automation to calculate a multi select list values.

Mat Levell

Hey all, Im trying to created a weighted priority score based on user selecting questions in a multi select list.
I first attempted to use a lookup table (similar to this thread) but I got stuck. I couldn't event get anything to wire to the Priority score (number field).

Screenshot 2024-08-14 at 12.53.46 PM.png Screenshot 2024-08-14 at 12.54.41 PM.png

I then abandoned the lookup table and tried multiple if statement

{{#=}}
{{#if(issue.customfield_10295.value.contains("Is the issue present on all vehicles?"))}}20{{/}}
+
{{#if(issue.customfield_10295.value.contains("Is the issue present on all models?"))}}50{{/}}
+
{{#if(issue.customfield_10295.value.contains("Does the issue result in a model being banned?"))}}100{{/}}
{{/}}

Screenshot 2024-08-15 at 2.29.25 PM.png

Any help would be amazing.

Accepted answers

Kalyan Sattaluri_iinm1n

Hello @Mat Levell

Please try to loop through the values and check individually...

{{#=}}0
{{#customfield_10295}}
{{#if(equals(value,"Is the issue present on all vehicles?"))}} + 20 {{/}}
{{#if(equals(value,"Is the issue present on all models?"))}} + 50 {{/}}
{{#if(equals(value,"Does the issue result in a model being banned?"))}} + 100 {{/}}
{{/}}
{{/}}

I just copied values from your example and if its not working, please try to log your values first and make sure the if conditions are evaluating correctly.. Hope it helps. Thanks!

All comments

Christopher Yen

Hi @Mat Levell

Welcome to the community!

Can you try this modified statement? I'm wondering if the if block end tags are causing an issue

{{#=}}
{{#if(issue.customfield_10295.value.contains("Is the issue present on all vehicles?"))}}20{{/if}}
+
{{#if(issue.customfield_10295.value.contains("Is the issue present on all models?"))}}50{{/if}}
+
{{#if(issue.customfield_10295.value.contains("Does the issue result in a model being banned?"))}}100{{/if}}
{{/}}

Mat Levell

@Christopher Yen Nope sadly no go.
Screenshot 2024-08-16 at 9.31.43 AM.png

Kalyan Sattaluri_iinm1n

Hello @Mat Levell

Please try to loop through the values and check individually...

I just copied values from your example and if its not working, please try to log your values first and make sure the if conditions are evaluating correctly.. Hope it helps. Thanks!

Mat Levell

@Kalyan Sattaluri This worked but I started top get into problems when I added too many questions. Is there a character limit in the simple field? When I try to put this in the advanced field I get and error saying "Error while parsing additional fields. Not valid JSON."

{{#=}}0

{{#if(equals(value,"Is the issue present on all vehicles?"))}} + 20 {{/}}

{{#if(equals(value,"Is the issue present on all models?"))}} + 50 {{/}}

{{#if(equals(value,"Does the issue result in a model being banned?"))}} + 100 {{/}}

{{#if(equals(value,”Does the issue make the vehicles effected unusable?”))}} + 50 {{/}}

{{#if(equals(value,”Does the issue happen more than once a day?”))}} + 10 {{/}}

{{#if(equals(value,”Does the issue happen more than once a run?”))}} + 20 {{/}}

{{#if(equals(value,”Is this issue blocking a performance work stream?”))}} + 50 {{/}}

{{#if(equals(value,”Is this issue blocking an internal work stream?”))}} + 50 {{/}}

{{/}}
Screenshot 2024-08-27 at 9.36.14 AM.png

Mat Levell

@Kalyan Sattaluri sorry to ping you again but Im pretty stuck here.

Kalyan Sattaluri_iinm1n

Hello @Mat Levell

I am not aware of any limitations to the count of If statement so I would have expected it to work.

This error --. "Error while parsing additional fields. Not valid JSON." usually means something is off with syntax but scanning through your post, syntax looks correct.

Have your tried to reduce number of if conditions 1 by 1 and check if fewer ones work? For ex, you have 8 statements now, have you tried to remove 1 and check if 7 works etc..

If lets say 5 if conditions work, and rest of the 3 dont.. an alternative is to break up your check into multiple smaller pieces..

So, you could create a variable and assign it the first 5 checks output.

Then create another variable and add next 3/remaining to previous value..

so you could try this work around..

Welcome!

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

Quick Links

Find more posts tagged with

cloud

automation

jira-service-management-cloud

jira-service-management