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