How to get the history of project assignment for an issue?

Hi,

I am trying to get a list of issues that were previously on a board, either raised there or at some point moved there.  For example I have tickets on boards B & C but I want to only show the issues that were on board A.

I thought I would be able to search the activity or use `WAS` on `Project` but that is not the case.  I am in an enterprise environment and there is no option to change the configuration or add plug-ins to the Jira installation.  We are running version v7.5.1#75006-sha1:7df2574

The eventual plan is to have a confluence page that summarises the tickets raised this week and the tickets that have been from board A during this period.

Thanks in advance,

Al 

2 answers

1 accepted

I found a solution using the REST API and jq.  This runs under bash:

curl -s -D- -X GET -H "Authorization: Basic YOUR_AUTH " -H "Content-Type: application/json" "https://jira.domain.tld/rest/api/2/search?jql=project%20%3D%20PROJECT_NAME%20AND%20created%20>%3D%20-1w&expand=changelog&maxResults=999"  | grep { | jq '.issues[].changelog.histories[].items[].fromString' | grep "PREVIOUS_PROJECT_NAME" | wc –l

 You will need to change YOUR_AUTH, domain.tld, PROJECT_NAME and PREVIOUS_PROJECT_NAME to suitable values for your search.

0 vote
Warren Levy Community Champion Jan 18, 2018

Hi Al

A board is just a "view" of issues, often only from one project, but can be from multiple projects.

If I understand your question correctly, you have one project and 3 boards. You're wanting to query which issues are showing or have been showing on board A - this is not possible.

Warren Levy Community Champion Jan 18, 2018

Going further with this, you must have some criteria which makes an issue show on board A but not on board B and C. These criteria could be used to extract the info you want.

Possibly show us the filter queries that you're using for each board and that may help us understand it

Hi, thanks for your response.  I don't mean Boards but Projects.  So I have some issues that were in Project A but are not in Project B and C.  I want to make a list of issues that were in Project A but now are not.

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 ...

3,296 views 14 20
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