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

[Kevin Kumar]

Hi there,

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

Thank you.

[Dave Rosenlund _Trundl_ · Accepted solution]

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_]

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

[Kevin Kumar]

sounds good, thank you @Dave Rosenlund _Trundl_ 

[Dan Breyen · Accepted solution]

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]

Thank you @Dan Breyen 

[Vijay Dadi]

Hello @Kevin Kumar ,

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

Thanks

Vijay