We are seeking to establish a Jira issue filter that precisely identifies issues generated during weekdays, specifically from Monday to Friday, and within the time frame of 9 AM to 6 PM for a designated month. Regrettably, the existing JQL query in use does not appear to be effectively filtering the issues to meet these criteria.

project = <projectkey> and created >= startOfMonth()  AND created <= endOfMonth()  AND  created >= startOfWeek("+1d") AND created <= endOfWeek("-1d") and created >= startOfDay("+8h") AND created <= startOfDay("+17h")

To rectify this issue, we need to refine our JQL query to accurately capture the desired set of issues. This revised query should encompass three key elements:

Date Range: It should isolate issues created within the confines of the chosen month.

Weekdays: The query must explicitly target weekdays, excluding weekends (Saturday and Sunday) and public holidays, to ensure only Monday through Friday are included.

Business Hours: Issues should be filtered based on the specified time frame, which is from 9 AM to 6 PM.

By crafting a JQL query that accounts for these criteria, we can tailor our filter to exclusively display issues that align with the precise requirements you've outlined, providing a more accurate representation of the data you need.