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

This widget could not be displayed.

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.

This widget could not be displayed.
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
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

169 views 2 0
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