Automation: Escalation process, JQL query issue

[Gentrit Cerimi]

Hello community,

I wanted to implement an escalation process when a overdue task is not done or resolved yet. We use "enddate" as the field where we fill in the issues' end date. 

Creating an automation with the jql query: 

enddate < now() AND status NOT IN (done)

 will give me the error

Invalid JQL
Field 'enddate' does not exist or you do not have permission to view it.

Thanks in advance.

Automation:

 

Enddate field:

[Stefan Salzl · Accepted solution]

Hi @Gentrit Cerimi  -- welcome to the community,

If this is the system field "End Date" (as it looks like in the screenshot) the jql needs to be the exact same string as the field´s name. Try the following jql:

"End Date" < now() AND status NOT IN (done)

Best
Stefan

[Gentrit Cerimi]

This worked ! Thank you very much

[Stefan Salzl]

AWESOME 🎉 Thanks for your feedback.

[Bill Sheboy]

Hi @Gentrit Cerimi 

Adding to Stefan's answer...

Smart values are name, spacing, and case-sensitive.  When in doubt of the exact smart value to use for a field, please try the information in this how-to article: https://support.atlassian.com/cloud-automation/docs/find-the-smart-value-for-a-field/

Kind regards,
Bill