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
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
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jack
Yes - it would be project specific
I will test this now and see if this works for me
Thank you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
i am getting errors with my flow - not sure how to read this to fix the issue
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
just getting back to this. You need to use the startofday(-5d) as a Condition not as part of the schedule. I think...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)}}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Audit Log for 1 Item
Action details:
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)...
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.
Audit Log for 1 Item
Action details:
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)...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I just ran this now
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)
None
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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")
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.