Creating a filter for shift report

[Rodriguez_ Jhon Ronald]

How can I create a filter for my two shift's team.
I want to know if how many tickets logged for this time duration(7am-7pm) dayshift. and (7pm-7am) Nightshift.

I have only JQL for the day. Here is my sample JQL in day.
project = "My Project" AND created > startOfDay(-1) AND created < endOfDay(-1)

[Sreenivasaraju P]

Hi @Rodriguez_ Jhon Ronald ,

As per my knowledge, out of the box this feature is not available.

You can try this with silJQLExpression of Power Scripts - Jira Workflow Automation

https://appfire.atlassian.net/wiki/spaces/PSJ/pages/15489314/Custom+JQL+Searches 

Refer below link for example.

https://community.atlassian.com/t5/Jira-questions/How-to-filter-tickets-specifically-by-time-of-day/qaq-p/1207641

[Joseph Chung Yin]

@Rodriguez_ Jhon Ronald -

In JQL - startofDay and endofDay can process hours as a syntax input.

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/#Advancedsearchingfunctionsreference-startOfDaystartOfDay--

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/#Advancedsearchingfunctionsreference-endOfDayendOfDay--

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.