Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

how to take weekend tickets alone using jql query for past 1 year

Sampath
Contributor
August 28, 2023

how to take weekend tickets alone using jql query for past 1 year any help highly appreciable

 

i have only month jql query

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))

1 answer

0 votes
Sayed Bares _ServiceRocket_
Community Champion
August 28, 2023

@Sampath try 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)))
Sampath
Contributor
August 29, 2023

Hi @Sayed Bares _ServiceRocket_ 

 

Awesome lovely thanks for your wonderful support 

Suggest an answer

Log in or Sign up to answer