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; } } }

Condition that triggers when multiple fields are not initiator nor empty

Quang Nguyen_cnxw26

I am trying to create a condition that triggers when there is at least one person who is not the initiator is in the assignee or reporter field, or the watchers list.

In other words, the rule should trigger when any one of these is true:

Assignee is not empty AND Assignee is not Initiator
Reporter is not empty AND Reporter is not Initiator
Watcher List contains at least one person who is not Initiator

I am currently trying to create this via a JQL query that reads

{{issue.assignee.emailAddress.remove(initiator.emailaddress)}} != empty OR {{issue.reporter.emailAddress.remove(initiator.emailaddress)}} != empty OR {{issue.watchers.emailAddress.remove(initiator.emailaddress)}} != empty

However I am getting the bug

(!= empty OR reporter@example.com != empty OR watcher1@example.com, watcher2@example.com != empty))" - 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 27)

I am the assignee in my test ticket, and it seems this rule is removing my name entirely, so it is creating a bug. How should I fix my JQL, or is there an easier way to do this?

I also previous tried to do it via multiple Advanced Compare Conditions, but could not add OR functionality to this.

Thanks!

Accepted answers

Bill Sheboy

Hi @Quang Nguyen

I recommend using an advanced compare condition, testing for equals, rather than a JQL condition.

Remember that JQL is not a SQL or programming language, and...

The issue is the JQL condition requires you to use well-formed JQL, and your use of smart value expressions on the left-side of comparisons can collapse to null. With JQL, the left-side of comparisons must be a valid issue field. Your audit log shows that you are trying to compare null (the absence of information) to empty, which cannot work with JQL.

Kind regards,
Bill

All comments

Marc -Devoteam-

Hi @Quang Nguyen

What app are you using in your system to set this JQL condition, as this is not ootb functionality within Jira Server?

Are you able to add screenshots in detail as well?

This will help community members to hopefully provide yoo with a solution

Quang Nguyen_cnxw26

Thanks for the suggestion Marc. I was not part of the team who set up our Jira so I'm unsure if this is ootb functionality, I just know I have access to JQL conditions.

Here's a screenshot of the rule:

Here's a screenshot of the error:

Bill Sheboy

Hi @Quang Nguyen

I recommend using an advanced compare condition, testing for equals, rather than a JQL condition.

Remember that JQL is not a SQL or programming language, and...

Kind regards,
Bill

Quang Nguyen_cnxw26

Hi @Bill Sheboy

Thank you for the suggestion. I tried doing it with Advanced Compare Conditions, but could not figure out how to use OR logic with this. I am trying to make the rule trigger when any one of the following is true, not when all three are true.

That is why I originally tried using JQL, so that I could use OR functionality.

Bill Sheboy

Sadly, there is no built-in OR for condition rule components...but there is a built-in OR function that can be used with conditional logic. Sorry if that is confusing.

Thus you can do this in one advanced compare condition, although it is messy:

first value:

{{#if(or(exists(issue.assignee.emailAddress.remove(initiator.emailAddress)),
or(exists(issue.reporter.emailAddress.remove(initiator.emailAddress)),
exists(issue.watchers.emailAddress.remove(initiator.emailAddress)))))}}true{{/}}

condition: equals

second value: true

The nested or() structure is needed because that function can only take two parameters. And I substituted to use exists() to test for non-null.

Quang Nguyen_cnxw26

Hi Bill,

Thanks for linking the OR documentation, that's new information for me!

I tried this, but it appears that the EXISTS function is always returning true. In the screenshot below, you can see the first audit log evaluating the smart value existing as true, however the second log is erroring out even though it is trying to evaluate the exact same smart value.

Do you have a link to the EXISTS documentation? I tried searching for that but could not find it.

Also, what does the # in your {{#if...}} do? I also saw that in the OR documentation but could not find its purpose.

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