nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Is there a way to remove all records by date in Changelogs?

Kalon Mitchell

We have over 14 million records in the Changelogs table in Jira. A record is created whenever most values are changed in a ticket. I use this table to create dashboards measuring the time between status changes in a ticket. The process to pull in this data nightly has become unmanageable. The table has a field for Issue Created Date, I would like to delete all records older than a specific date, can this be done?

Accepted answers

All comments

Tuncay Senturk _Snapbytes_

Hi @Kalon Mitchell

Welcome to the community.

As far as I know it is not possible via API. On the other hand, you can do that deleting those records in the changehistory and changeitem database tables but that's always tricky and not recommended.

I do not think it is a good idea to calculate that data from database, as it would not be a performant way. Also, it would have a bad impact on database statistics/index hits. Instead, you should use Java/REST API to get changelogs and calculate duration.

As an alternative, you can use an app for that data without a need to delete any data.

Enhancer Plugin for Jira has Time Between custom field which will give you the duration between status changes, even with any defined working calendar.

I hope it helps

Tuncay

Kalon Mitchell

I understand your answer, but in my case, it does not apply. I am pulling in the data to Sisense using a data connector and duplicating the log file in a Sisense data model. This connector uses the Jira APIs and I can't access these APIs or the Jira database directly. I can use a query in the connector to exclude records, but this creates another problem where the connection times out as millions of records are being bypassed. I need a way to actually shrink this file in the Jira database. This process now takes 5 hours, reducing the size of the log file is the only way to solve it.

Kalon Mitchell

What happens when this file gets too large? Is this not an issue for anyone else? Any log file can potentially fill up any amount of available disk space if given enough time and activity.

Tuncay Senturk _Snapbytes_

Hi @Kalon Mitchell

I am a bit confused. Are you talking about a log file or the database table?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server