Site announcement

We are switching off article comments on this website. Read about the upcoming changes to Atlassian Documentation.

Documentation for JIRA 6.4 (This documentation includes the project navigation sidebar). Not using this? See below:
(JIRA 6.4 without sidebar documentation | JIRA 6.3.x documentation | JIRA Cloud documentation | earlier versions of JIRA)

Skip to end of metadata
Go to start of metadata

An issue's change history is a record of changes made to an issue, including:

  • creator of the issue (this may be the same as the reporter, but can be distinct)
  • changes to an issue field
  • attachment of a file
  • deletion of a comment
  • deletion of a worklog
  • creation or deletion of an issue link

For each change, the following is recorded:

  • the person who made the change
  • the time at which the change was made
  • if an issue field was changed, the new and old values of the field

To view an issue's change history,

  1. Open the relevant issue in JIRA.
  2. Open the History tab in the Activity section.
  3. The list of changes to the issue will display, similar to the screen shot below.

Screen shot: An Issue's History

10 Comments

  1. Anonymous

    how to query who changed?

    1. Open the issue, click the History tab, see who did the change.

       

      JQL History search is almost totally useless because it only works with very few fields.

      You can do queries like "Which user changed this field?" on a handful of built-in fields only (such as Priority). For example, you can search who changed a prio this week, using a query like this:

      ... AND Priority changed by "username" DURING (startofweek(), endofweek()) AND ...

       

      If you tried this same query with most other fields, e.g. Issuetype or a "Severity" custom field, you'll get the error message "History searches do not support the '[field name]' field."

       

      http://blogs.atlassian.com/2013/02/jql-the-most-flexible-way-to-search-jira-24/

       

      Advanced Searching

  2. Anonymous

    How do we export it without any plug in? This should have been the default feature!

  3. Anonymous

    I need that query pls

  4. The database schema for change history is described at Change History.  I didn't find a new version of the page but the schema appears to still be valid.  I'm using SQL Server and wrote the following snippet to let me query for history based on the user-friendly issue key:

     

    1. Hi John,  I gave your script to our dba & he tried it out, but I don't understand the returns.  For example he tested this out on one issue and the return values were OLDVALUE=10040 OLDSTRING=New NEWVALUE=10047 NEWSTRING=Backlog.  In attempting to gather the Time In New status for each ticket; when I looked at the specific ticket he ran the test on, the data reflects 32m21s for Time in Source Status - this is the data we are trying to capture.  So I'm not sure how the OLDVALUE & NEWVALUE translates to the 32m21s?  Any help you can provide is greatly appreciated!

  5. Hi John Price, Just poking to see if you can answer my question above.  Thanks!

    1. Huh... your @ reference sent me an email, but I'm not the person that asked the question above.

      1. John Price - I didn't realize how many John Price entries there were.  Sorry about that, I'm looking for the John Price that published the SQL script above.

  6. It's a bit stupid that recent changes show as a very ill-defined time of "3 hours ago" or "yesterday" instead of the actual time it was done.

    The ones further in the past have a datetime for the change, but not recent ones, this is extremely irritating because I use this to find out when I made a change so I can figure out how much work to log.

    Stupid...