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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

Bulk operation without affecting "Updated" field Edited

What is the current way to bulk operations that don't change the "Updated" value?

While cleaning the system (by canonizing types or tags for example), the Updated field gets changed to current systime. When searching for tasks, the field itself is siginifantly more valuable the less rewarding a term alone is. 

I've found some ressources but no officially supported way to do it, there are even warnings applying handcrafted queries to the database.*

While doing the search, I found a somehow related issue. Please look at that Updated and Created fields, and unfold the History panel:

https://jira.atlassian.com/browse/JRASERVER-7831

 

*) https://confluence.atlassian.com/jirakb/how-to-change-the-issue-creation-date-using-a-database-update-334430256.html

 

While this link went offline:

https://confluence.atlassian.com/display/JIRAKB/How+to+modify+an+issue+creation+date

 

Thanks!

Daniel

 

1 answer

0 votes
Thomas Deiler Community Leader Mar 16, 2019

Dear @Daniel Wendler ,

this how Jira is designed. Either you

  • (not recommended) shut down jira and alter the data via SQL
  • you export your project to XML (dump) modify the data and re-import overwriting the old information.

So long

Thomas

Hi Thomas and thanks for your reply,

I am not sure if exporting and importing of maybe 100.000 tasks is an appropriate solution to fixing JIRAs design issue :-(

So far the "Updated" field is useless by design, too bad.

 

Regards.

Daniel

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Jira Software

Presenting the "Best of 2020" Jira Software roundup!

Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...

3,675 views 5 15
Join discussion

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