Actualy I can connect in the database and return the all issues in the table "jiraissue" filtering Closed issue (status 6) and Resolved (status 10114). Now I need identify which user Close and Resolved this Issues. In the table "jiraissue" I can see any collums which usernames, for example: (reporter, assignee, creator), but I'm not sure what Nope, you can leave them in "ready for acceptance" or the three green ones. That's what boards are for - representing the workflow in a way that suits each particular team. When your developers do a sprint report, they'll see those issues as done. When the sprint is closed, the done issues don't change. Task 2: paint a box. sub-task - choose paint. sub-task - paint box. >>>link to Task 1 "is blocked by". Task 3: sell a box. >>>link to Task 2 "is blocked by". with all that said, one could certainly make task 2 and 3 sub-tasks of task 1 but then you lose any order relationship that a link could provide. Reply. And we have a different set of status values in the new workflow we’re moving to. For all our existing issues Jira just needs to know how we’re going to map these different status values. What we want is to map like this… Current New TO DO Open IN PROGRESS In Progress Resolved Reopened DONE Closed A few things worth pointing out: 1. I want to capture the chart showing created versus closed. All I can find is created vs resolved. We are using JIRA for problem tracking and tasks, not SW development. I don't know how to create gadgets but I copied the createdvsresolved xml file and opened it in Oxygen so I could do a find/replace for all the words "resolved". I want my query to show all issues that are either open now or were closed within the last x number of days. Essentially, tickets closed more than x days ago will "fall off" the board/query. Here is what I have: project = FUS AND (resolved >= -1d OR status != "Resolved") ORDER BY cf [10011] ASC, created DESC. Previous plans. In most helpdesks, a ticket can have one of four statuses: Open, Pending, Resolved, or Closed. When a ticket requires any action from you or your agents, it is marked as Open, which means every new ticket is marked Open by default. When your agents require additional information from the customer, instead of letting your SLA 2. publish the workflow, you can save a copy. 3. Go to issue navigator find all issues that are in status CLOSED and resolution is Unresolved. 4. In the top right corner, you will see Tools click on that bulk change. 5. Select all issues. 6. Choose transition issues -> choose Done fix. Answer. Tickets are set to solved first, and then, after a pre-defined amount of time, they move to closed status. The major differences between solved and closed tickets are below. Solved tickets can be reopened and updated. Tickets in solved status, that are not closed by a trigger or automation, are automatically closed after 28 days through However there are a couple of different ways to do that. Cause #1. The first is in regards to the way the workflow is setup to move between issue statuses. If the flow is a single direction, say Todo -> In progress -> Done, with no transitions that can be executed regardless of the current state, like so. A1qPY3V.