Reports

[Sampath]

Team

I would like to take past 1-year  Weekend tickets (incident , request subtask) its there any easy query to take it

pls advise thanks

i am using server / data center

[Sayed Bares _ServiceRocket_]

@Sampath 

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:

1. Use a third-party app available in the marketplace which extends JQL functionalities
2. Export your past 1 year data and then use spreadsheets or Excel to filter out issues on weekends
3. 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 
4. Use Automation + customfield to mark issues which are created on weekends, this can be a permanent solution if you need this report in future

[Sampath]

Hi @Sayed Bares _ServiceRocket_ 

Thanks for your response and support

Third party not possible only via JQL or anyother alternative , any possible solution pls share it thanks

[Sampath]

Hi @Johnny Mon 

could you pls help on exact JOQ query thanks

I would like to take past 1-year  Weekend tickets (incident , request subtask) its there any easy query to take it

pls advise thanks

[Sampath]

Hi @Sayed Bares _ServiceRocket_ @

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

[Sayed Bares _ServiceRocket_]

@Sampath you will need to extend your queries to include all 52 weeks (104 query in total). Your query is only taking 4 weeks into consideration.

[Sampath]

@Sayed Bares _ServiceRocket_ 

Let me check, in between if you have share query it will be helpful thanks

[Sayed Bares _ServiceRocket_]

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

[Sampath]

Hi @Sayed Bares _ServiceRocket_ 

Lovely support from your always grateful thanks for your support