nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

get reopen issues per user

Laureano G

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

Accepted answers

All comments

Nic Brough -Adaptavist-

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?

Laureano G

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

Nic Brough -Adaptavist-

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.

Laureano G

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.

Mauro Cendon

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

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>

Mauro Cendon

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

Enter Cookie as format:
(ex: name=val;) separate with ';'
<input type="text" id="cookieInjectorCookie"/>

Mauro Cendon

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

Andrey Markelov

try this: https://marketplace.atlassian.com/plugins/ru.andreymarkelov.atlas.plugins.datacollector