How to locate tickets that were changed after it was approved

[Sam Tsao]

PROBLEM STATEMENT

Need to identify tickets that were changed by users after it was approved.

Changes: update the ticket description, summary, any of the fields, adding or removing attachments, etc.  Changes made by JIRA progression are excluded.

DETAILS

Our Change Management process prohibits anyone to make changes to the JIRA ticket once it was approved for Production release.

I need to write a JIRA query to return a list of tickets that were changed when the JIRA status reached a certain stage.

Thank you in advance for your guidance.

[Chris Buzon]

You can't really do that cleanly with basic JQL alone, at least not that I know of. 

It is possible to create a system to do that with Jira automation, using the Edit event (any time a ticket is edited) and checking to see if the ticket is approved, or in a status after approval, then labeling, setting a field, or sending a message to slack/email/teams, commenting, etc).

You can also use Conditions or post-functions in a many ways to prevent issues from being edited after a certain point, but they're quite specific to your team and how they work.