Comment a list of fields that meet criteria

[Jeremy Wood]

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? 

[Aaron Pavez _ServiceRocket_]

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