How can I filter all change data in my custom field?

I want to create filter to show all data which selectd in custom field(Bottleneck) that I created type Multi Select.

all data --> old data ( before change ) & new data (after change)

I wanted New Value in this picture.

If I use field bottleneck in filter , it show only new data updated. But I want to show old and new data.(history data) How can I do?

3 answers

JQL does not support this functionality.

you would need to get this information out of your database. Look for tables changeitem and changegroup.

Do you have plugin or something to help If I don't to select in database?

It's not so much JQL or the search that doesn't support this, it's a matter of display. JQL finds issues, it doesn't say anything about what is displayed. The view screens determine what you see on-screen, and they do it with a combination of code to display the screen and code for each field that tells it how to display.

Most fields are self-contained - you can think of the view screen as saying "for this issue, how do I display the contents of this field?" and the field saying "here's the html you need". A multi-select field is written to display the current data.

The change history is available on the issue, so what you need is a field that will read that and display it, instead of just showing the current value.

I'm not aware of any plugin that will do this, but you could write one. I suspect a "scripted field" is the best bet - instead of writing a whole plugin to provide a multiselect, I would suggest you stick with your multi-select, and write a second field that simply displays the history of it - I think the script-runner plugin could to this.

Can't add much to Nics comment. I'm not aware of such a plugin either.

Thank you so much

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,826 views 12 18
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot