Filter to find field value that has changed more than 3 times.

Jeremy Price

Hello All,

I'm trying to create a filter where the component is changed more than 3 times for a specific field on an issue. 

Once that field value has changed more than 3 times I would like to pull those issue into a filter.

Mark Segall

Hi @Jeremy Price - You won't be able to do this natively without some workarounds...

1. Create a custom Number Field
2. Create an automation rule to tally up that field each time the component changes

The automation rule would look like this:

• TRIGGER: Field Value Changed (Component)
• ACTION: Edit Issue (Your custom field)

  • {{#=}}{{issue.Your Custom Field}}+1{{/}} 

Now you can use JQL against that field:

"Your Custom Field" > 3

NOTE - You want greater than 3 here because the first component setting already gives the custom field a value of 1.