Jira Automation Scheduled Trigger: JQL Search

[Cole Dickens]

I'm trying to configure a scheduled automation to trigger an action based on the value (date) on my ' Last Working Day' custom field (customfield_10714).  When I attempt to validate the query via JQL search, I get the error:

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

I also receive the same error for my other custom field (customfield_10748).  I've verified that this custom field does exist and that it contains the correct value (date) via Postman.  I've also verified that I have the correct permissions to view it.

Here is my JQL search:

customfield_10714 = startOfDay() AND customfield_10748 = "Scheduled Offboarding" AND status != "Completed"

I'll admit that JQL is not my strength and it's somewhat new to me so maybe I'm doing something wrong here or I simply don't understand how/what is being validated.  Is it looking for existing open requests/issues?

Any help would be greatly appreciated.

[Trudy Claspill · Accepted solution]

Hello @Cole Dickens 

Welcome to the Atlassian community.

You can use the Issue Search screen to build the filter you need and then copy the JQL from there to your Automation Rule. The Issue Search screen has autocompletion suggestions and both JQL and basic views to help you create filters.

https://support.atlassian.com/jira-software-cloud/docs/search-for-issues-in-jira/

[Cole Dickens]

This worked perfectly. Thanks for the tip.

[Alexis Robert]

Hi @Cole Dickens , 

for JQL the syntax is a bit different, this is what you should use : 

cf[10066] = startOfDay()

This way works fine in Automation too, so that should solve your issue.

Let me know if this helps, 

--Alexis

[Cole Dickens]

Thanks for the suggestion, Alexis.