Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Restrict Issue History when importing a single project


I am importing a single project in JIRA , JIRA shows as *ProjectImport* under *IssueHistory* & *Actvity* Tab of each issue in that project.

I don't need JIRA to show this history. PFA

Please let me know the possible workaround.

2 answers

1 accepted

0 votes
Answer accepted

You can delete the entries from changegroup and change item tables

you will have to run two queries , first to delete entries from changegroup then from changeitem

this is the first query

delete from changegroup where id IN (select ci.ID from changeitem ci,changegroup cg where field='ProjectImport' and cg.ID=ci.groupid);

this is the second query

delete from changeitem where field='ProjectImport';

this should delete all the entries from both the table and nothing about project import will be displayed in history

NOTE:first query should be executed first and then the second one

If you're going to edit the issue history with SQL, then you absolutely MUST

  1. Stop Jira
  2. Backup the database
  3. Test the backup
  4. Run the SQL
  5. Restart Jira
  6. Re-index it

Never never never run SQL updates against a running Jira, you can easily destroy it. (There are minor exceptions, and the damage isn't always catastrophic, but the advice remains "don't")

Thanks Nic & Mizan .

It worked for me .

On most events, you can place view restrictions (like on comments). What you can try is to restrict the viewing of this import event to admins only. That way normal users should not see this event. Not sure how you can do that though.

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you