how can i search deleted jira ticket via SQL?

[Nate _이슬기_ _Project Management_ _]

Dear All,

I am a business analyst and we use JIRA as CRM.

i have a problem in filtering deleted ticket in JIRA.

IN 'jiraissue' table, there is no value or column to recognize 'delete or not'.

Could you help this issue?

Regards

Nate

[Joe Pitt · Accepted solution]

Do not delete issues. When you delete it is GONE. Hardly a week goes by without someone wanting to restore an issue. Deleting issues will come back and bite you when it is the most inconvenient. I suggest closing with a resolution value of Deleted anything you want to delete. I implement a special transition only the project lead can execute and it requires filling in a reason field from a select list (such as entered in error, OBE, Duplicate, Other) and explanation text.

Missing issue numbers will eventually cause a question about what it was and why was it deleted even if it was done properly. Missing data always brings in the question of people hiding something that may have looked bad.

The only viable way to restore an issue is to create a new instance of JIRA and restore a backup that has the issues. Then export them to a csv file and import them to your production instance. You will lose the history.

[Nic Brough -Adaptavist- · Accepted solution]

The best you can do with SQL is a negative search.  Get a list of issues that do exist, look for "holes" in the numbers, check any numbers that are missing against the moved issues, and if you are missing there, you know they've been deleted.

You could also check the audit log, but bear in mind that can be turned off, and only goes back a certain time.

And yes, deleted means deleted, the issues are gone from the database.

[Rambabu Patina _Appfire_ · Accepted solution]

Unfortunately, you can't. Deleted issues are gone.

The only option is to import a backup from previous days into a Test JIRA instance, find your issue from the database and get its details.

[Fazila Ashraf · Accepted solution]

Hi Nate

Deleted issues are totally removed . Only available issues are in the db

[Nate _이슬기_ _Project Management_ _]

Hi, Fazila.

You mean that 'deleted ticket' is deleted even in Database?

Thanks

[Fazila Ashraf]

Hi Nate,

Yes, they are deleted even in the database