nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Automation: Getting JQL error

Gisela Lassahn

Hi everybody,

I'm using Automation in Jira Data Center with rule triggered by "Issue linked".

I've created an If-block with the following JQL:

{{issue.project}} not in (STCS, ITGOV) or {{issue.issuetype}} != Epic or {{destinationIssue.project}} not in (STCS, ITGOV) or {{destinationIssue.issuetype}} != Epic or {{destinationIssue.project}} = {{issue.project}}

I'm getting an JQL error saying:

Fehler in der JQL-Abfrage: Das Zeichen "{" ist ein reserviertes JQL-Zeichen. Sie müssen es stattdessen in eine Zeichenfolge einfügen oder das Escapezeichen "\u007b" verwenden. (Zeile 1, Zeichen 41)

Translated in English:

JQL query error: The "{" character is a reserved JQL character. You'll need to put it in a string instead, or use the "{" escape. (line 1, character 41)

What am I doing wrong and how should my JQL look like?

Many thanks for your help and best regards,
Gisela Lassahn

Accepted answers

All comments

Manoj Kumar Gangwar

Hi @Gisela Lassahn

Could you please try the below JQL and check?

{{issue.project}} not in ("STCS", "ITGOV") or {{issue.issuetype}} != "Epic" or {{destinationIssue.project}} not in ("STCS", "ITGOV") or {{destinationIssue.issuetype}} != "Epic" or {{destinationIssue.project}} = "{{issue.project}}"

Gisela Lassahn

Hi @Manoj Kumar Gangwar ,

I've tried your JQL but I'm still getting exactly the same error message.

In the message details I can see that my JQL is resolved to:
(key IN (ITGOV-66) AND (SmartProjectBean{source=Project{self='https://jira....

The "{" after "SmartProjectBean" is on position 41 and seems to cause the problem.

Gisela Lassahn

@Manoj Kumar Gangwar ,

I've found workaround.

No I have two Smart Value Variables:

ProjectShortcut, defined as: {{issue.key.substringBefore("-")}}
DestinationProjectShortcut, defined as: {{destinationIssue.key.substringBefore("-")}}

Now I can work with these variables.

Many thanks to you for your time!

John Funk

Hi Gisela,

Try using just:

issuetype != Epic

it’s just JQL so you shouldn’t need the smart value there.

Gisela Lassahn

@Manoj Kumar Gangwar :

Now I've got another problem.

My JQL now is:

"{{ProjectShortcut}}" not in ("STCS", "ITGOV") or "{{issue.issuetype.name}}" != "Epic" or "{{DestinationProjectShortcut}}" not in ("STCS", "ITGOV") or "{{destinationIssue.issuetype.name}}" != "Epic" or "{{DestinationProjectShortcut}}" = "{{ProjectShortcut}}"

The error message is:

... error running JQL: "(key IN (ITGOV-66) AND ("ITGOV" not in ("STCS", "ITGOV") or "Epic" != "Epic" or "UTK" not in ("STCS", "ITGOV") or "Story" != "Epic" or "UTK" = "ITGOV"))" - Feld 'ITGOV' existiert nicht., Feld 'Epic' existiert nicht., Feld 'UTK' existiert nicht., Feld 'Story' existiert nicht.

In English:

Field 'ITGOV' does not exist., Field 'Epic' does not exist., Field 'UTK' does not exist., Field 'Story' does not exist

Gisela Lassahn

Hi @John Funk ,

I could do this for the trigger issue, but not for the destination issue, or am I wrong?

John Funk

Correct. But the error is for character 41, which is before that.

Bill Sheboy

Hi @Gisela Lassahn

If I understand your question, the JQL statement you show is not valid.

JQL statements have this syntax: some_issue_field OPERATOR some_value

For example: project IN (ABC, DEF)

Instead you are trying this: some_value OPERATOR some_other_value

For example: ABC IN (DEF)

And so there are no issue fields referenced, leading to the syntax errors. (JQL is not a SQL, and so does not support those types of logical / comparison operations of data.)

Without knowing the specifics of the problem you are trying to solve, I believe you could either use Issue Conditions or Advanced Compare Conditions, testing the smart values with logical operators.

Kind regards,
Bill

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server

jira-data-center

data-center