Project Automation if date is greater than today+5day transition to resolved

[Robin Stemmers]

Hi All

I hope you can help - Newbie to Jira Project Automation.

I want to auto resolve an issue based on a date +5 days .

If my date = 25 October 2020 then 5 days later it must transition to Resolved.

My Date is a custom field.

What is the condition I must use to complete the above action?

Can you provide me with the correct syntax.

__________________________________________________________

I get the error below when i try my options

Action details:

JQL condition

No subsequent actions were performed since JQL condition did not pass due to error running JQL:"(key IN (FSSQA-86) AND (2020-10-05 = 2020-10-12T09:20:17.6+0000))" - Error in the JQL Query: The character '+' is a reserved JQL character. You must enclose it in a string or use the escape '\u002b' instead. (line 1, character 59)

Thanks in Advance

[John Funk]

@felix.weber  - So you are saying that works for you? 

[Jack Brickey]

I think you want to set up a scheduled automation that runs daily and the condition would be a JQL like this - ...and “my date” = startofday(“-5d”)...

I recommend having this at the project level not global and add other limiting conditions if possible,

[Robin Stemmers]

Hi Jack

Yes - it would be project specific

I will test this now and see if this works for me

Thank you

[Robin Stemmers]

Hi

i am getting errors with my flow - not sure how to read this to fix the issue

[John Funk]

I have not used the " around the days before - just startOfDay(-5d)

[Jack Brickey]

just getting back to this. You need to use the startofday(-5d) as a Condition not as part of the schedule. I think...

[Robin Stemmers]

Hi - This is still not working for me - what am i doing wrong?

I have used that scheduled trigger and this is my JQL entry

{{issue.customfield_10225}} = {{startofday(-5d)}}

[John Funk]

What error are you getting? Or what is the result of when it runs?  Can you share the audit log?

[John Funk]

And did you add the query as a condition as well?

[Robin Stemmers]

Audit Log for 1 Item

Action details:

JQL condition

No subsequent actions were performed since JQL condition did not pass due to error running JQL:

"(key IN (FSSQA-81) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25), "(key IN (FSSQA-78) AND (2020-10-10 =))" - Error in JQL Query: Expecting either a value, list or function but got ')'. You must surround ')' in quotation marks to use it as a value. (line 1, character 37), "(key IN (FSSQA-77) AND (2020-10-09 =))" - Error in JQL Query: Expecting either a value, list or function but got ')'. You must surround ')' in quotation marks to use it as a value. (line 1, character 37), "(key IN (FSSQA-85) AND (2020-10-11 =))" - Error in JQL Query: Expecting either a value, list or function but got ')'. You must surround ')' in quotation marks to use it as a value. (line 1, character 37), "(key IN (FSSQA-82) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25), "(key IN (FSSQA-79) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25), "(key IN (FSSQA-84) AND (2020-10-30 =))" - Error in JQL Query: Expecting either a value, list or function but got ')'. You must surround ')' in quotation marks to use it as a value. (line 1, character 37), "(key IN (FSSQA-86) AND (2020-10-05 =))" - Error in JQL Query: Expecting either a value, list or function but got ')'. You must surround ')' in quotation marks to use it as a value. (line 1, character 37), "(key IN (FSSQA-83) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25), "(key IN (FSSQA-80) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25), "(key IN (FSSQA-75) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25), "(key IN (FSSQA-76) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25), "(key IN (FSSQA-71) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25), "(key IN (FSSQA-74) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25), "(key IN (FSSQA-72) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25), "(key IN (FSSQA-73) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25), "(key IN (FSSQA-70) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25), "(key IN (FSSQA-69) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25), "(key IN (FSSQA-68) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25), "(key IN (FSSQA-67) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25)...

[Robin Stemmers]

[Robin Stemmers]

Audit Log for 1 Item

Action details:

JQL condition

No subsequent actions were performed since JQL condition did not pass due to error running JQL:

"(key IN (FSSQA-81) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25), "(key IN (FSSQA-78) AND (2020-10-10 =))" - Error in JQL Query: Expecting either a value, list or function but got ')'. You must surround ')' in quotation marks to use it as a value. (line 1, character 37), "(key IN (FSSQA-77) AND (2020-10-09 =))" - Error in JQL Query: Expecting either a value, list or function but got ')'. You must surround ')' in quotation marks to use it as a value. (line 1, character 37), "(key IN (FSSQA-85) AND (2020-10-11 =))" - Error in JQL Query: Expecting either a value, list or function but got ')'. You must surround ')' in quotation marks to use it as a value. (line 1, character 37), "(key IN (FSSQA-82) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25), "(key IN (FSSQA-79) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25), "(key IN (FSSQA-84) AND (2020-10-30 =))" - Error in JQL Query: Expecting either a value, list or function but got ')'. You must surround ')' in quotation marks to use it as a value. (line 1, character 37), "(key IN (FSSQA-86) AND (2020-10-05 =))" - Error in JQL Query: Expecting either a value, list or function but got ')'. You must surround ')' in quotation marks to use it as a value. (line 1, character 37), "(key IN (FSSQA-83) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25), "(key IN (FSSQA-80) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25), "(key IN (FSSQA-75) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25), "(key IN (FSSQA-76) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25), "(key IN (FSSQA-71) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25), "(key IN (FSSQA-74) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25), "(key IN (FSSQA-72) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25), "(key IN (FSSQA-73) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25), "(key IN (FSSQA-70) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25), "(key IN (FSSQA-69) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25), "(key IN (FSSQA-68) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25), "(key IN (FSSQA-67) AND (=))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 25)...

[John Funk]

And can you show the Audit Log when you test it?

[Robin Stemmers]

Hi

I just ran this now

Action details:

Scheduled

Error running query for scheduled JQL trigger:"('=') AND (project in (10210))" - Error in the JQL Query: Expecting operator but got ')'. The valid operators are '=', '!=', '<', '>', '<=', '>=', '~', '!~', 'IN', 'NOT IN', 'IS' and 'IS NOT'. (line 1, character 5)

Associated items:

None

[Robin Stemmers]

Action details:

Scheduled

Error running query for scheduled JQL trigger:"(=) AND (project in (10210))" - Error in the JQL Query: Expecting a field name but got '='. You must surround '=' in quotation marks to use it as a field name. (line 1, character 2)

[felix.weber]

Hi @Robin Stemmers  

 I guess this has already been solved - however as there is no finally answer and I faced a similar issue I solved it in this way (in my case I am checking for issues where my customfield date will match in 2 weeks ( be aware of the "=" this makes sure it matches exactly in 2 weeks)

my JQL is just a normal JQL not using directly a smartvalue:

project = "Test" AND "My Customfield Date[Date]" = startOfDay("2w")