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.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.