I need to create a query in an automation to find the first ticket of the day or to create an automatic ticket daily at a specific time.
I already have several ideas but I need to use a query that works
Hi @Eliana Acosta , the following query would find all issues created in project "abc" for the current day up to the time the query is executed.
project = abc and created >= startofday()
regarding creating an issue each day at a certain time you would use Automation. The basic structure of the rule would be:
Hi @Eliana Acosta
Creating an issue at a specific time is the easier option:
---
The other option is a little more complex, but still possible. Example below:
The "Lookup Issues" action locates all issues created since the start of the day, and the smart value {{lookupIssues.first}} finds the first item in the list.
You can change the Trigger/Branch-Action to whatever is needed for you
Ste
@Eliana Acosta -
Welcome to the community. For the JQL search to identified the 1st issue created in each day will be -
project = <your project key> and created >= startofday() order by created asc
For automation rule setup, you can create a "scheduled" automation rule triggered at a specific time to create your issues. The triggering event can be setup as a cron setup.
Here is a reference link on Scheduled trigger - https://support.atlassian.com/cloud-automation/docs/jira-automation-triggers/#Scheduled
Hope this also helps.
Best, Joseph Chung Yin
Jira/JSM Functional Lead, Global Technology Applications Team
Viasat Inc.
Tks! But this validation was not found --> JQL - clave = {{lookupIssues.first}}
For dynamic searches, validation is not available. This is only available for a static JQL.
It should still work though when you test the rule.
It looks like you're new here. Sign in or register to get started.
