How to Create a query of tickets that are generated every weekend?

Kevin Kumar May 7, 2024

Hi there,

how can i write a query to generate tickets that come in every weekend constantly to track?

 

Thank you.

3 answers

2 accepted

2 votes
Answer accepted
Dave Rosenlund _Trundl_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 7, 2024

Hi, @Kevin Kumar. Someone may suggest something better, but assuming you do this on Monday morning, off the top of my head:

created < now() AND created > endofDay (-3)

should do the trick.

Then save the JQL as a filter.

Best,

-dave

Dave Rosenlund _Trundl_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 7, 2024

You may want to be more specific with the '< date' -- that's up to you.

Kevin Kumar May 7, 2024

sounds good, thank you @Dave Rosenlund _Trundl_ 

Like Dave Rosenlund _Trundl_ likes this
0 votes
Answer accepted
Dan Breyen
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 7, 2024

Hi Kevin, I'm no expert with Automation, but I believe you could create an Automation to run on every Saturday (or whenever) and have the action be 'Create Issue'.  Then you can create whatever tickets you need.

Hope that helps.

Kevin Kumar May 7, 2024

Thank you @Dan Breyen 

0 votes
Vijay Dadi
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 8, 2024

Hello @Kevin Kumar ,

You can try this filter also - created >= startOfWeek() AND created <= endOfWeek()

Thanks

Vijay

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events