Run automation rule from transition

[Benjamin Peikes]

Seems like one of the first things that Jira should support is running an automation rule from a transition, but I can't seem to figure out how to do it.

I believe that I could do it the following way, but it seems like a total hack:

1) Create an automation rule which is triggered from an external webhook

2) Add a webhook to our system that points to the automation rules webhook

3) In the post function of the transition, run an "external webhook", which just points to our automation webhook. I'm not sure if the hooks are compatible though.

Thoughts?

[Nic Brough -Adaptavist-]

Reading the JIRA database is usually a terrible way to do anything, as it's "designed" to be a datastore for JIRA, not any form or reporting tool.

Could you explain what you are trying to achieve?  As there is a better way to do it than using the database.

-----

But, to answer the technical part, start with the JiraIssue table.  That has

A project field, which you can use to read the project table

An issuetype field which contains an id that is the id in the issuetype table

an issue id on it (a unique immutiable one, not the ones the humans see)

The issue id can be used to find a ChangeGroup record, which is a container for the lines of history with a date and user on them.  You use the id in the changegroup to identify the changeitem lines that belong to a group, and those tell you each field that changed during that update

CustomField is a header table, describing what the custom fields are

CustomFieldValue contains the actual values for issues - you'll find the issue id and the CustomField.ID on them to tell you which issue data is hed in which field.

As you can see from that, it's really not a nice layout for reporting.  Hence the advice that you don't want to do it this way.