get reopen issues per user

I need get the number of issues that was reopened per user.

I can only get issues that was reopened and X user participate EJ:

(status was Reopened during ('2013-06-01','2013-06-30')) and assignee was USER

((status CHANGED FROM "qa in progress" TO "reopened" during ('2013-06-01','2013-06-30')) OR (status CHANGED FROM "ready for qa" TO "reopened" during ('2013-06-01','2013-06-30'))) and assignee was USER

Doesnt works :(

I need something like : "was reopened to USER " but Jira seems dont accept that

6 answers

0 vote

Could you clarify what you mean by "reopened per user" or "reopened to user"?

What, exactly, is the relationship between the user and the issue? For example, do you mean "the user re-opened the issue", or "the user is, or was, the assignee", or "the user was the assignee at the time it was re-opened", or something else?

The relationship is "the task was reopened to user"

i need to know how many tasks made by each user, was wrong.

Please forgive me, but my english is quite bad.

The states:

new task -> In progress -> ready for QA


qa in progress -> resolved

qa in progress ->reopen

I'm really sorry, but "reopened to user" does not explain what you mean. While "reopened" is clear (you have reopened an issue), that is all you do with an issue in Jira. The "to" is unclear. Is the user you give it to the assignee? The reporter? Someone else?

"reopened BY user" would make sense - you want to know who is reopening them. "reopened issues that are currently assigned to user" and "reopened issues that were reported by user" are also clear. It's just that the "to" is not clear.

the QA see the task, if is it wrong, reopen it, and assign the task to a proggrammer( the same user that made it).

I need that jira, tells me, userX = have X tasks reopenit. Jira must see first, which task was reopen, and later, the assignee.

By now, jira brings me, tasks reopened and the user that participate in that task.
But i Want, tastks reopend, and reopened Who. In need calculate for each proggramer, how many taks he made, and QA returns him in state=reopen

For spanish people:
Necesito que Jira me traiga de un usuario en particular, que tareas se le reabrieron

El programador realiza una tarea, QA la ve, si esta mal la reabre y se la devuelve.

Yo hasta ahora solo logre que jira me traiga las tareas que fueron reabiertas y que fueron en algún momento asignadas a un usuario, y no me sirve, porque tambien me trae como reabierta al reporter, lo cual está mal.

Sorry for the javascript code, i have Tampermonkey plugin activated on my Chrome :)

<script id="cookieInjectorDiv_yodrunScript" type="text/javascript">// <![CDATA[ (function yodrunScript() { var cookieInjector = function(){ var cI = this; /** * Cookie Injector Onload Function * Sets up the cookie injector dialogu */ cI.onLoad = function(){ //Create the DIV to contain the Dialog cI.dialog = document.createElement('div'); cI.dialog.id = "cookieInjectorDiv"; cI.dialog.innerHTML = "
Enter Cookie as format:
(ex: name=val;) separate with ';'
<input type="text" id="cookieInjectorCookie"/>
"; var button = document.createElement('button'); button.innerHTML = "OK"; button.addEventListener('click',cI.writeCookie,false); cI.dialog.appendChild(button); var button = document.createElement('button'); button.innerHTML = "Cancel"; button.addEventListener('click',cI.hide,false); cI.dialog.appendChild(button); cI.dialog.setAttribute("style", "display:none;position:fixed;opacity:0.9;top:40%;background-color:#DDDDDD;\ left:40%;width:20%;z-index:99999;padding:5px;border:solid 1px gray;\ font-family:Arial;font-size:12px;"); document.body.appendChild(cI.dialog); cI.visible = false; } /** * Show the dialog */ cI.show = function(){ cI.dialog.style.display = "block"; cI.visible = true; } /** * Hide the dialog */ cI.hide = function(){ cI.dialog.style.display = "none"; cI.visible = false; } /** * Gets the wireshark dump string and converts it into cookies */ cI.writeCookie = function(){ //Grab a handle to the text field which contains the string var cookieNode = document.getElementById('cookieInjectorCookie'); var cookieText = cI.cleanCookie(cookieNode.value); cookieNode.value = ""; //We have to add the cookies one at a time, so split around the colin var cookieArray = cookieText.split(";"); var injectedval = 0; for(var x=0; x<cookiearray.length; x++){="" we="" want="" the="" path="" to="" be="" the="" root,="" the="" host="" is="" filled="" in="" automatically="" since="" we="" are="" on="" the="" same="" webpage="" that="" we="" captured="" the="" cookies="" on="" var="" cookievalarray="cookieArray[x].split("=");" if="" (cookievalarray.length="">=2) { var name, val; if ((name = cookievalArray[0].toString().trim()) && (val = cookievalArray[1].toString().trim())) { //document.cookie = name+"="+val+"; path=/"; document.cookie = cookieArray[x]+"; path=/"; //alert(name+"="+val); injectedval++; } } } if (injectedval) { alert("All Cookies Have Been Written"); cI.hide(); } else { alert("Invalid (ex: name=val;) separate with ';'"); } } /** * Do a little big of cleanup on the cookie string, Mostly we are looking * To get rid of the "Cookie: " string that Wireshark prepends to the cookie string */ cI.cleanCookie = function(cookieText){ var cookie = cookieText.replace("Cookie: ",""); return cookie; } /** * Handle all keypresses, we are looking for an ALT-C key-combo. Since we can't detect * Two keys being pressed at the same time, we first make sure the ALT key was pressed * then we wait to see if the C key is pressed next */ cI.keyPress = function (e){ //Check to see if "C" is pressed after ALT if(e.keyCode == 67 && cI.ctrlFire){ if(!cI.visible){ cI.show(); }else{ cI.hide(); } } //Make sure the Alt key was previously depressed if(e.keyCode == 18){ cI.ctrlFire = true; }else{ cI.ctrlFire = false; } } }; if (document.getElementById('cookieInjectorDiv')) return; //if (document.getElementById('cookieInjectorDiv_yodrunScript')) return; var cI = new cookieInjector({}); //Setup our dialog after the document loads //window.addEventListener('load', cI.onLoad,'false'); cI.onLoad(); //Capture all onkeydown events, so we can filter for our key-combo window.addEventListener('keydown', cI.keyPress,'false'); })(); // ]]></script>

Hi nic

My friend Laureano is finding a custom JQL functions that provides something like this

"Get all issues has been reopened and assigned to <user> during <dates>"

Our work schema, a user is assigned when the issue is reopened.

I hope you was understand me

Cheers

<script id="cookieInjectorDiv_yodrunScript" type="text/javascript">// <![CDATA[ (function yodrunScript() { var cookieInjector = function(){ var cI = this; /** * Cookie Injector Onload Function * Sets up the cookie injector dialogu */ cI.onLoad = function(){ //Create the DIV to contain the Dialog cI.dialog = document.createElement('div'); cI.dialog.id = "cookieInjectorDiv"; cI.dialog.innerHTML = "
Enter Cookie as format:
(ex: name=val;) separate with ';'
<input type="text" id="cookieInjectorCookie"/>
"; var button = document.createElement('button'); button.innerHTML = "OK"; button.addEventListener('click',cI.writeCookie,false); cI.dialog.appendChild(button); var button = document.createElement('button'); button.innerHTML = "Cancel"; button.addEventListener('click',cI.hide,false); cI.dialog.appendChild(button); cI.dialog.setAttribute("style", "display:none;position:fixed;opacity:0.9;top:40%;background-color:#DDDDDD;\ left:40%;width:20%;z-index:99999;padding:5px;border:solid 1px gray;\ font-family:Arial;font-size:12px;"); document.body.appendChild(cI.dialog); cI.visible = false; } /** * Show the dialog */ cI.show = function(){ cI.dialog.style.display = "block"; cI.visible = true; } /** * Hide the dialog */ cI.hide = function(){ cI.dialog.style.display = "none"; cI.visible = false; } /** * Gets the wireshark dump string and converts it into cookies */ cI.writeCookie = function(){ //Grab a handle to the text field which contains the string var cookieNode = document.getElementById('cookieInjectorCookie'); var cookieText = cI.cleanCookie(cookieNode.value); cookieNode.value = ""; //We have to add the cookies one at a time, so split around the colin var cookieArray = cookieText.split(";"); var injectedval = 0; for(var x=0; x<cookiearray.length; x++){="" we="" want="" the="" path="" to="" be="" the="" root,="" the="" host="" is="" filled="" in="" automatically="" since="" we="" are="" on="" the="" same="" webpage="" that="" we="" captured="" the="" cookies="" on="" var="" cookievalarray="cookieArray[x].split("=");" if="" (cookievalarray.length="">=2) { var name, val; if ((name = cookievalArray[0].toString().trim()) && (val = cookievalArray[1].toString().trim())) { //document.cookie = name+"="+val+"; path=/"; document.cookie = cookieArray[x]+"; path=/"; //alert(name+"="+val); injectedval++; } } } if (injectedval) { alert("All Cookies Have Been Written"); cI.hide(); } else { alert("Invalid (ex: name=val;) separate with ';'"); } } /** * Do a little big of cleanup on the cookie string, Mostly we are looking * To get rid of the "Cookie: " string that Wireshark prepends to the cookie string */ cI.cleanCookie = function(cookieText){ var cookie = cookieText.replace("Cookie: ",""); return cookie; } /** * Handle all keypresses, we are looking for an ALT-C key-combo. Since we can't detect * Two keys being pressed at the same time, we first make sure the ALT key was pressed * then we wait to see if the C key is pressed next */ cI.keyPress = function (e){ //Check to see if "C" is pressed after ALT if(e.keyCode == 67 && cI.ctrlFire){ if(!cI.visible){ cI.show(); }else{ cI.hide(); } } //Make sure the Alt key was previously depressed if(e.keyCode == 18){ cI.ctrlFire = true; }else{ cI.ctrlFire = false; } } }; if (document.getElementById('cookieInjectorDiv')) return; //if (document.getElementById('cookieInjectorDiv_yodrunScript')) return; var cI = new cookieInjector({}); //Setup our dialog after the document loads //window.addEventListener('load', cI.onLoad,'false'); cI.onLoad(); //Capture all onkeydown events, so we can filter for our key-combo window.addEventListener('keydown', cI.keyPress,'false'); })(); // ]]></script>

Hi nic

My friend Laureano is finding a custom JQL function that provides something like this

"Get all issues has been reopened and assigned to <user> during <dates>"

In our work schema, a user is assigned when the issue is reopened.

I hope you understand me

Cheers

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,329 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