You may use startOWeek/endOfWeek functions to target weekends but directly excluding/including weekends for a date range is not supported OOTB.
Here are some alternatives that you may consider:
Use a third-party app available in the marketplace which extends JQL functionalities
Export your past 1 year data and then use spreadsheets or Excel to filter out issues on weekends
NOT recommended, write a JQL query for all 52 weekends of the past year (this will include 2 (1 query for start of weekend and 1 query for end of the weekend) *52 = 104 queries) using startOWeek/endOfWeek functions which is very manual and error prone
Use Automation + customfield to mark issues which are created on weekends, this can be a permanent solution if you need this report in future
Could you pls help on this i can only take one month
project = XXX AND "Support Level" = "XXX" AND (createdDate >= startOfWeek(-1d) AND createdDate < startOfWeek(1d) OR createdDate >= startOfWeek(-8d) AND createdDate < startOfWeek(-6d) OR createdDate >= startOfWeek(-15d) AND createdDate < startOfWeek(-13d) OR createdDate >= startOfWeek(-22d) AND createdDate < startOfWeek(-20d))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Sampath your query should be something like this:
project = XXX AND "Support Level" = "XXX" AND ((createdDate >= startOfWeek(-1d) AND createdDate < startOfWeek(1d)) OR (createdDate >= startOfWeek(-8d) AND createdDate < startOfWeek(-6d)) OR (createdDate >= startOfWeek(-15d) AND createdDate < startOfWeek(-13d)) OR (createdDate >= startOfWeek(-22d) AND createdDate < startOfWeek(-20d)) OR (createdDate >= startOfWeek(-29d) AND createdDate < startOfWeek(-27d)) OR (createdDate >= startOfWeek(-36d) AND createdDate < startOfWeek(-34d)) OR (createdDate >= startOfWeek(-43d) AND createdDate < startOfWeek(-41d)) OR (createdDate >= startOfWeek(-50d) AND createdDate < startOfWeek(-48d)) OR (createdDate >= startOfWeek(-57d) AND createdDate < startOfWeek(-55d)) OR (createdDate >= startOfWeek(-64d) AND createdDate < startOfWeek(-62d)) OR (createdDate >= startOfWeek(-71d) AND createdDate < startOfWeek(-69d)) OR (createdDate >= startOfWeek(-78d) AND createdDate < startOfWeek(-76d)) OR (createdDate >= startOfWeek(-85d) AND createdDate < startOfWeek(-83d)) OR (createdDate >= startOfWeek(-92d) AND createdDate < startOfWeek(-90d)) OR (createdDate >= startOfWeek(-99d) AND createdDate < startOfWeek(-97d)) OR (createdDate >= startOfWeek(-106d) AND createdDate < startOfWeek(-104d)) OR (createdDate >= startOfWeek(-113d) AND createdDate < startOfWeek(-111d)) OR (createdDate >= startOfWeek(-120d) AND createdDate < startOfWeek(-118d)) OR (createdDate >= startOfWeek(-127d) AND createdDate < startOfWeek(-125d)) OR (createdDate >= startOfWeek(-134d) AND createdDate < startOfWeek(-132d)) OR (createdDate >= startOfWeek(-141d) AND createdDate < startOfWeek(-139d)) OR (createdDate >= startOfWeek(-148d) AND createdDate < startOfWeek(-146d)) OR (createdDate >= startOfWeek(-155d) AND createdDate < startOfWeek(-153d)) OR (createdDate >= startOfWeek(-162d) AND createdDate < startOfWeek(-160d)) OR (createdDate >= startOfWeek(-169d) AND createdDate < startOfWeek(-167d)) OR (createdDate >= startOfWeek(-176d) AND createdDate < startOfWeek(-174d)) OR (createdDate >= startOfWeek(-183d) AND createdDate < startOfWeek(-181d)) OR (createdDate >= startOfWeek(-190d) AND createdDate < startOfWeek(-188d)) OR (createdDate >= startOfWeek(-197d) AND createdDate < startOfWeek(-195d)) OR (createdDate >= startOfWeek(-204d) AND createdDate < startOfWeek(-202d)) OR (createdDate >= startOfWeek(-211d) AND createdDate < startOfWeek(-209d)) OR (createdDate >= startOfWeek(-218d) AND createdDate < startOfWeek(-216d)) OR (createdDate >= startOfWeek(-225d) AND createdDate < startOfWeek(-223d)) OR (createdDate >= startOfWeek(-232d) AND createdDate < startOfWeek(-230d)) OR (createdDate >= startOfWeek(-239d) AND createdDate < startOfWeek(-237d)) OR (createdDate >= startOfWeek(-246d) AND createdDate < startOfWeek(-244d)) OR (createdDate >= startOfWeek(-253d) AND createdDate < startOfWeek(-251d)) OR (createdDate >= startOfWeek(-260d) AND createdDate < startOfWeek(-258d)) OR (createdDate >= startOfWeek(-267d) AND createdDate < startOfWeek(-265d)) OR (createdDate >= startOfWeek(-274d) AND createdDate < startOfWeek(-272d)) OR (createdDate >= startOfWeek(-281d) AND createdDate < startOfWeek(-279d)) OR (createdDate >= startOfWeek(-288d) AND createdDate < startOfWeek(-286d)) OR (createdDate >= startOfWeek(-295d) AND createdDate < startOfWeek(-293d)) OR (createdDate >= startOfWeek(-302d) AND createdDate < startOfWeek(-300d)) OR (createdDate >= startOfWeek(-309d) AND createdDate < startOfWeek(-307d)) OR (createdDate >= startOfWeek(-316d) AND createdDate < startOfWeek(-314d)) OR (createdDate >= startOfWeek(-323d) AND createdDate < startOfWeek(-321d)) OR (createdDate >= startOfWeek(-330d) AND createdDate < startOfWeek(-328d)) OR (createdDate >= startOfWeek(-337d) AND createdDate < startOfWeek(-335d)) OR (createdDate >= startOfWeek(-344d) AND createdDate < startOfWeek(-342d)) OR (createdDate >= startOfWeek(-351d) AND createdDate < startOfWeek(-349d)) OR (createdDate >= startOfWeek(-358d) AND createdDate < startOfWeek(-356d)))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.