Audit log error

[Sinisa Glusac]

Hi,

I've created one automation in my sandbox that includes multiple projects, but I keep getting an error in the audit log. However, automation works all the time perfectly, I just want to get rid of the error. Automation adds a specific value to the "labels" field for all projects that are linked with the parent link. The error is:

"(issuekey = and project in (ALGI, FER, AMA, WO)) AND (project in (10019,10018,10020,10033,10014))" - Error in JQL Query: Expecting either a value, list or function but got 'and'. You must surround 'and' in quotation marks to use it as a value. (line 1, character 14).

Please find attached the screenshot of the automation and error message. I tried many different combinations, and also googled a lot, but without success. Please advise. Thank you in advance.

BR,
Sinisa

[Patricia Francezi · Accepted solution]

Good day @Sinisa Glusac 

I see your jql in this part 

(issuekey = and project in

you have "= and"

issuekey should be a issuekey number, not a operator AND. 

[Sinisa Glusac]

Hi @Patricia Francezi , thank you for your answer! I'm quite new in Jira, and not sure that I understood your solution, can you, please, give me some example? Thank you in advance. 

[Patricia Francezi]

Hi! No problem

Your JQL is incorret

in this example:

((issuekey = Bugs AND project in (ALGI, FER, AMA, WO))

after operator = is expected to have a VALUE, and not a clause. project in (... is a new clause and not a value. 

The value is Bug, or Story or any issue type you want to have that.

as in project in the values are ALGI, FER, etc... 

I hope I had clarified now, and if not, let me know. 

ALso refer to those kbs https://support.atlassian.com/jira-software-cloud/docs/use-advanced-search-with-jira-query-language-jql/

[Sinisa Glusac]

Ok, I will test to see if works, thank you