find all the Jira for a month period, which was opened within a specified time

[Saurabh Malhotra]

Hi,

I am able to create a search to find all the Jira for a project, which was created in a month and created at a specified time on daily basis for that month.

Below one did not worked and gave me the output for 1 day only and not for all the days for the month.

project IN ("DI","Data Ingestion Engineering") AND component = "ingestion" AND ((created >= startOfMonth() AND created <= endOfMonth() ) and (createdDate >= startOfDay("-5h") AND createdDate <= startOfDay("+7h"))) ORDER BY created DESC.

Can someone please help me.

[Aron Gombas _Midori_]

@Saurabh Malhotra As others suggested it is relatively easy to do after you exported your issues (incl. the creation dates) to Excel.

If you want to stay within Jira, it could be done like this:

1. Add a number type custom field "Creation hour within the day" or something
2. Implement a simple automation rule which
   1. is triggered by issue creations
   2. writes the current hour to that custom field

This custom field is indexed and searchable in JQL! It should be faily easy actually.

[Duc Thang TRAN]

Hello @Saurabh Malhotra 

it because this part  (createdDate >= startOfDay("-5h") AND createdDate <= startOfDay("+7h"))) .

This will show you only the results for the day you make this request.

I don't think you can retrieve created tickets for the month without a plugin. 

Maybe it's easier to extract all tickets for the month via Excel and then filter in Excel.

project IN ("DI","Data Ingestion Engineering") AND component = "ingestion" AND ((created >= startOfMonth() AND created <= endOfMonth() )

Best :)

[Saurabh Malhotra]

I am already using Excel, but this type of request is important when we need to check which region is getting how many ticket and good for reporting purposes. But afraid to see Jira does not have any way to extract this information.

Anyways thanks for the help.

[Duc Thang TRAN]

@Saurabh Malhotra 

In this case, I suggest creating an automation rule and a custom field (type: radio button) named "Business Hours" with Yes and No values. If the ticket is created between 7 PM and 7 AM, automate it to modify the field and set the value to No.

With this solution, you can add in your JQL: "Business Hours" = No

Or someone with more experience might have a different solution to suggest.