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 Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Monday in Jira Software

How large do you think Jira Software can grow?

Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...

708 views 6 13
Read article

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