Comment a list of fields that meet criteria

Question

Hello Atlassian Community,

My company is currently to improve our vendor risk process. Currently we have a form that gets completed by the vendor that asks them questions such as, "Is your company SOC2 Compliant?" Based on the answers they provide we set a risk value (Yes = 1, No = 10) and calculate the total risk score for the vendor.

This is currently being done manually but we are in the process of creating a Jira automation using lookup tables to calculate this score for us.

What we would like is a way to list out the individual questions where a users answered resulted in a high score. (In the example, List SOC2 as a no) so that we can quickly review what the high value contributors were to the score.

Does anyone have suggestions on how i might go about this?

Jeremy Wood · Answer

Hi Aaron. Thank you for the response. But that's not what we are looking for. Let me try to explain further.

So we have a list of about 30 questions that we ask vendors. We want an automation that will look through all of the answers they provided and then create a comment (Or write to a different custom field) the list of questions that they provided high risk answers to.

To give an example:

Question 1: A= 1 point, B=5points, C=10 Points

Question 2:  A= 1 point, B=10 points

Question 3: A= 1 point, B=5points, C=10 Points

If a user answers C, B, A i want a comment that rights "High Risk Questions: 1, 2 Total Score: 21"

If a user answers  A, A, C, it would comment "High Risk Questions: 3 Total Score 12"

That way we can quickly look  at what answers gave the higher score.

Aaron Pavez _ServiceRocket_ · Answer

Hi @Jeremy Wood

With JQL.

SOC2 = No. If there are any other values, you need to add SOC2 IN (Value1,Value2)

That will give you a list of all work items where SOC2 is no.

Regards