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

How to select issues based on activity history?

We have a custom field containing a number and I'd like to query (JQL if possible) for all occurrences of field changes.  For example, Leases Entered is changed from 0 to 10, I'd like to know who and when that change was made.  Any thoughts?

2 answers

Hello @Bill Kunneke 

There is not native functionality available for JQL for that. Are you open to adding a 3rd party app to your instance?

Can you describe the problem you are trying to solve by querying for this information?

Sure.  We have a custom field containing a number and that number will get updated occasionally.  When the field is updated, it appears in the Activity - History for the issue.  I can write the JQL to get recent activity with something like updatedDate >= -1d.  But I want to see the Activity - History associated with the issue.  Using the UI, I can see this in the issue details:

Bill Kunneke updated the Custom Count seconds ago

0 -> 5

For this change, I'd like to get the data that shows the value changed from 0 to 5.  The data is there, I just can't figure out how to get to it.  My team is logging changes, I just can't report on it.  I'm open to using a 3rd party for this.

0 votes

Hi @Bill Kunneke

history searches are only available for some fields, for example for the assignee

assignee changed AFTER -2d

There is a Suggestion open with Atlassian to improve this and make history searches available to custom fields, please make sure to vote and watch it:

Although this does not fix your issue immediately it shows that the topic is of relevance to your team.

One (clunky) option would be to export data to CSV (regularly) and check for changes in a spreadsheet tool. For field changes you could also work with Automation but only a solution where you get a Slack message or an e-mail would come to my mind.
Depending on how you want to proceed with the information about the changed data (or the changed data itself) this might not be of any help.

Probably, like Trudy said, there will still be recommendations for Apps by other Community members.


Suggest an answer

Log in or Sign up to answer
Site Admin
Community showcase
Published in Jira

⏰ Day in the life of a Jira Admin!

Hello Community! We thoroughly enjoyed this just-for-fun conversation in the Jira Admin Group about what it's like to be a Jira Admin. For #JiraJuly, our talented designers created these graphics t...

64 views 0 6
Read article

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