nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Automation failing because jql can't read input date

Katie Sobolik_0l65a7

I am trying to run this automation, which should be triggered manually, then prompt for a startDate. That start date should be input into this jql filter query:

project = "Data Management" and summary ~ "dbt Job Run: Test_Center.Test" and issuetype = "Test Execution" and created >= {{startDate}}

This is the failure I get from the audit log:

Manual trigger from issue 02/19/2025, 09:32:28

Create variable 02/19/2025, 09:32:28

JQL condition 02/19/2025, 09:32:28 JQL didn't run, which prevented the JQL condition from passing and its actions from being executed: Invalid JQL: project = "Data Management" and summary ~ "dbt Job Run: Test_Center.Test" and issuetype = "Test Execution" and created >=

I know the issue is around the startDate, but I can't figure out how to fix it. This is the variable: Variable name = startDate Smart value={{userInputs.startDate}}

Any help would be appreciated

Accepted answers

Vishal Biyani_2pr07j

@Katie Sobolik

Assuming your variable name is: startDate and your input date is 02/19/2025 09:32:28 and you need to use time part, then below will work. / is a reserved keyword for JQL and your date format is giving errors. JQL does not take seconds so that needs to be removed.

if your format was in yyyy-mm-dd format, then it would have worked as it.

project = "Data Management" and summary ~ "dbt Job Run: Test_Center.Test" and issuetype = "Test Execution" and created > {{userInputs.startDate.toDate("MM/dd/yyyy H:m:s").format("yyyy-mm-dd H:m")}}

Apologies for the multiple edits as the time part had to be incorporated as well.

All comments

John Funk

Hi Katie - Welcome to the Atlassian Community!

Try this: {{userInputs.startDate.jiraDate}}

Vishal Biyani_2pr07j

@Katie Sobolik

if your format was in yyyy-mm-dd format, then it would have worked as it.

project = "Data Management" and summary ~ "dbt Job Run: Test_Center.Test" and issuetype = "Test Execution" and created > {{userInputs.startDate.toDate("MM/dd/yyyy H:m:s").format("yyyy-mm-dd H:m")}}

Apologies for the multiple edits as the time part had to be incorporated as well.

Katie Sobolik_0l65a7

made the updates and still receiving the same error. also updated the startDate

Vishal Biyani_2pr07j

project = "Data Management" and summary ~ "dbt Job Run: Test_Center.Test" and issuetype = "Test Execution" and created > {{userInputs.startDate.toDate("MM/dd/yyyy H:m:s").format("yyyy-mm-dd H:m")}}

Check with this date 02/19/2025 09:32:28

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-cloud