How to extract the list of all the Jira workflows modified in a specific period .

[Pankaj Mahajan]

Hello,

I am trying to extract a list of all the jira workflows that were modified in a certain period just for an example 180 days in this case. 

I am running on Jira Software and using a Oracle DB in the backend.

I am sure that we can pull the data for the fields or issues but not sure about workflows whether that would be available in the DB or not. 

A small help will also be appreciated . 

Thanks in Advance!!

Regards,

Pankaj 

[Peter-Dave Sheehan]

Pretty much everything is in the DB.

Workflows are stored in the jiraworkflows and jiradraftworkflow tables.

But the trick will be to filter my modified date. There is no such column in the database. Instead, you'll have to find a way to look inside the value of the "DESCRIPTOR" column with is stored as XML.

You'll see a couple of XML nodes like this that might be helpful:

<meta name="jira.update.author.key">xxxx</meta>
<meta name="jira.updated.date">1646175344339</meta>

Where the date is stored as milliseconds since epoch time.

You'll have better luck in oracle forums for how to achieve that.