Mehmet A _Bloompeak_ Atlassian Partner

Hi @Jason Liu , The data you need is available in issue history and you can get it using the issue REST API. It provides the exact status change date time for each issue. /rest/api/2/issue/{issueIdOrKey}?expand=changelog

Your regex should match <client-ip>,<load-balancer-ip>,<GFE-IP><backend-IP>. ^XX\.XX\.XX\.[0-9]+,.*$ In the above regex, "XX\.XX\.XX\.[0-9]+" matches client-ip. The remaining ",.*" matches ",<load-balancer-ip>,<GFE-IP><backend-IP>".

Hi @Luke , If you are looking for a tool, you can try Status Time app developed by our team.It provides reports on how much time passed in each status. By grouping statuses you can get cycle time(E.g from in progress status to done status). You can also export the report as CSV and open it in excel. Once you enter your…

Hi @Bill Sheboy , Yes you are right, it returns all labels. I missed single project requirement.

Hi @Luke , Yes, this the correct and only rest api that you can use. The data you need is available in issue history and you can get it using rest api. It provides the exact status changes for each issue. It returns json, then you need to calculate it by coding which parses issue history rest api json for each issue.

Hi @[deleted] , As an alternative you can try label rest api. https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-labels/#api-rest-api-3-label-get

Most probably, you see the load balancer ip in "remote-addr". The load balancer must be adding the actual remote address into another header( maybe x-forwarded-for or true-client-ip). Or there might be configuration on load balancer to speciy the name of this header. You can change the urlrewrite.xml condition to check…

It is just regex. For instance if your ip range is from XX.XX.XX.0 to XX.XX.XX.255, then you can use ^XX\.XX\.XX\.[0-9]+$

Hi @sreenivasulu vadde , Maybe the below condition format works. <condition type="remote-addr" operator="notequal">^XX\.XX\.XX\.XX$</condition>

Hi @SHEHZADALI ISMAILY , Unfortunately, what you are looking for is not possible with the built-in functionalities of JQL. Because JQL can not make calculations and you need status time calculation. For this exact need we developed Status Time Jira app. It provides reports on how much time passed in each status. By…

Hi @Daria Pavlova , welcome to the Atlassian Community! Unfortunately, what you are looking for is not possible with the built-in functionalities of Jira and JQL. Because JQL can not make calculations and you need status time calculation. For this exact need we developed Status Time Jira app. It provides reports on how…

Hi @Ilya Konovalov , welcome to the Atlassian Community! Unfortunately, what you are looking for is not possible with the built-in functionalities of JQL. Because JQL can not make calculations and you need status time calculation. For this exact need we developed Status Time Jira app. It provides reports on how much time…

Hi @Dalcina Duval , Status Time Free and Status Time apps do not set "time in status" field. Instead they calculate the time in each status on-the-fly when you open the reporting page or the issue detail page.

Hi @Victor Tobon , Unfortunately, what you are looking for is not possible with the built-in functionalities of JQL. Because JQL can not make calculations and you need status time calculation. For this exact need we developed Status Time Jira app. It provides reports on how much time passed in each status. By grouping…

Hi @kavita.desai , Unfortunately, what you are looking for is not possible with the built-in functionalities of JQL. Because JQL can not make calculations and you need status time to be calculated For this exact need we developed Status Time Jira app. It provides reports on how much time passed in each status. By grouping…

Hi @Christoph Winkler , Unfortunately, what you are looking for is not possible with the built-in functionalities of JQL. Because JQL can not make calculations and you need status time calculations. For this exact need we developed Status Time Jira app. It provides reports on how much time passed in each status. By…

Hi @Pascal , Unfortunately, what you are looking for is not possible with the built-in functionalities of JQL. Because JQL can not make calculations and you need status time calculations. For this exact need we developed Status Time Jira app. It provides reports on how much time passed in each status. By grouping statuses…

Hi @18601949127 , These tickets are the ones that are first responded on this week. So the count of these tickets is denominator. Sum of first response times of these tickets is numerator.

Hi @Sindhu D M , If you installed the pro version(Status Time Jira app) of Status Time Free. You can also show/hide navigation bar item per user/group using "Access Settings" as in the below screenshot. So that it will only visible to the ones you allow. Regarding the emaling feature, I suggest that you generate the report…

Hi @Maribel Pinillos , If you are looking for the time spent in status(e.g "waiting for support" time ) per organization then you can use Status Time Jira app developed by our team. By default it displays time spent on each status for each issue. But it has grouping feature in which you can get sum/average time spent on…

Hi @violeta.marquez , The data you need is available in issue history and you can get it using Jira Rest API. It provides the exact resolution date changes for each issue. It returns json, then you need to calculate it by coding which parses issue history rest api json for each issue. Or you can try marketplace apps. We…

Hi @John Price , As you mentioned the data you need is available in issue history and you can get it using Jira Rest API. It provides the exact assignee change date and time for each issue. It returns json, then you need to calculate it by coding which parses issue history rest api json for each issue. Or you can try…

Hi @Patrick Uzer , welcome to the Atlassian Community! You can use the get issue REST API along with expand=changelog parameter. Then you need to parse json response and search for status changes in changelog->histories. /rest/api/2/issue/{issueIdOrKey}?expand=changelog

Hi @yashwanth, welcome to the Atlassian Community! Unfortunately, what you are looking for is not possible with the built-in functionalities of JQL. Because JQL can not make calculations and you need waiting time to be calculated. For this exact need we developed Status Time Jira app. It provides reports on how much time…

Hi @RM Unfortunately, what you are looking for is not possible with the built-in functionalities of JQL. Because JQL can not make calculations and you need resolution time to be calculated first. For this exact need we developed Status Time Jira app. It provides reports on how much time passed in each status. By grouping…

Hi @Paulina Mijal , You can try Status Time Jira app developed by our team. It provides reports on how much time passed in each status. Using "Report type:Sum" and "Group by: Epic Name" settings of the report, you get time spent per epic. Once you enter your working calendar into the app, it takes your working schedule…

Hi @Hritik Vinayak Lal, Welcome to the Atlassian Community! As an alternative you can try Status Time Jira app developed by our team. It has 1-month trial period, at least you can install it and compare it with the control chart. The app provides reports on how much time passed in each status. By grouping statuses you can…

Hi @Doug Pflueger , As an alternative you can try Status Time Jira app developed by our team. It has 1-month trial period, at least you can install it and compare the report with the control chart. It will help you to find out the problem with the control chart. The app provides reports on how much time passed in each…

Hi @John Tucci , For this exact need we developed Status Time Jira app. It provides reports on how much time passed in each status. By grouping statuses you can get resolution time(E.g from new status to done status). You can also export the report as CSV. Once you enter your working calendar into the app, it takes your…

Hi @Sudharsan , For this exact need we developed Status Time Jira app. It provides reports on how much time passed in each status. By grouping statuses you can get resolution time(E.g from new status to done status). You can also export the report as CSV. Once you enter your working calendar into the app, it takes your…