Tempo de tarefa parada no status

[Julio Cesar]

Pessoal, 

Desejo criar um filtro que liste todas as atividade por determinado status e que mostre quantos dias está neste status.

É possível?

Vejo que o próprio Jira já mostra isso nos cards (tarefas). Mas quero lista todas as tarefas que estão em um determinado status há mais de 7 dias.

Feito isso, quero enviar e-mail para os responsáveis dessas atividades.

[Elisa Cerri E Cerri]

I would like to know the time spent for each issue, is that possible?

[Bill Sheboy]

Hi @Elisa Cerri E Cerri -- Welcome to the Atlassian Community!

Are you asking about seeing the time in each status?

If so, you may see that with the built-in control chart report: https://support.atlassian.com/jira-software-cloud/docs/view-and-understand-the-control-chart/

Unfortunately that report has some limitations.  The work-arounds for those are to measure time-in-status yourself, using automation rules and custom fields, or to purchase better reporting from the Atlassian marketplace apps.

Kind regards,
Bill

[Elisa Cerri E Cerri]

Thanks Bill! :-)

[Diego Marques Oliveira]

Pessoal, bom dia. 

Como faço para realizar uma consulta no Jira que mostre qts dias meus card ficaram na coluna "Em progresso"?

Guys, good morning.  How do I perform a query in Jira that shows how many days my cards were in the "In Progress" column?

[Bill Sheboy]

Hi @Diego Marques Oliveira -- Welcome to the Atlassian Community!

This is a very old thread, and so I recommend always adding a new question and including a link back to older threads for context.  That will ensure the maximum number of people see your question to offer ideas.

To save you some time: what you ask is not possible with the built-in JQL.  You could view the data in column using the Jira board's features, or investigate a marketplace addon to JQL which supports calculated data fields.

Kind regards,
Bill

[Bill Sheboy]

Hi @Julio Cesar -- Welcome to the Atlassian Community!

I will assume you want to do this only for the "in progress" issues... You may list those issues with this query, substituting in the name of your project:

project = myProject
 AND statusCategory = "In Progress"
 AND NOT status CHANGED AFTER -7d

If you are using a company-managed project, you could also add this filter as a "quick filter" to the board.  You may also save this filter, subscribe to it, and receive an email on a schedule of your choice.  Please look here to learn about that feature of Jira: https://support.atlassian.com/jira-software-cloud/docs/save-your-search-as-a-filter/

The individual emails part of your request is slightly more difficult.  When you note "those responsible for these activities" do you mean the assigned user?  Some options for that are to:

• Forward an email from the filter subscription to people with assigned issues
• Update the above filter with a "currentUser() check, and ask everyone on the team to subscribe to the filter

project = myProject
 AND statusCategory = "In Progress"
 AND NOT status CHANGED AFTER -7d
 AND assignee = currentUser()

Best regards,

Bill

[Julio Cesar]

Hi Bill,

Thnks for your help.  

After your help I achieved resolved my problem.

Thanks, my friend. \o/

Julio.