filtering out tickets for which one field has changed

[Paulina Mijal]

Hi, is it possible to build such a JQL so that I am able to find a list of tickets to which the value of the custom field has been changed? I would like to know:
1. which Epics have been linked to Initiatives in the last month (via the Parent Link field).
2. in which Epics the value of one checkbox type field has been verified. 

Thanks

[Lisa Forstberg · Accepted solution]

Hi @Paulina Mijal ,

As far as I know and if you are using the Jira out of the box functionality and no addons  I am afraid I would say no.

You want to query on whether or not the issue is or was (at a specific interval) linked or if a custom field has changed. 

In JQL we can query on WAS, WAS IN, WAS NOT and on CHANGED however these operators are limited to only search in Assignee, Fix Version, Priority, Reporter, Resolution, and Status.

Here is the doc for the advanced searching https://confluence.atlassian.com/jiracoreserver/advanced-searching-fields-reference-939937719.html 

Not sure even addon scriptrunner can manage to query this.

br

/Lisa