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
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
Tks! But this validation was not found --> JQL - clave = {{lookupIssues.first}}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
Ste
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.