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)
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
@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.
It looks like you're new here. Sign in or register to get started.
