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

Smart value for not and equals operator not working

Amit Bansal_mz9tfs

Team - I am trying to create an automation rule to print all sprint items however would like to ignore all issue types with status as "Cancelled" and "Invalid". Below is the query but it is not working. Any help would be greatly appreciated!

{{#lookupIssues}}
{{#if(not(equals(issue.status.name,"CANCELLED")))}}
{{issueType.name}} - <{{url}}|{{key}}> - _{{summary}}_ {{status.name}} is due on {{dueDate}}.
{{/}}
{{/}}

Accepted answers

Hana Kučerová

Hi @Amit Bansal ,

please try status (or status.name) instead of issue.status.name in the condition.

See here for more info:

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-issues/

All comments

Hana Kučerová

Hi @Amit Bansal ,

please try status (or status.name) instead of issue.status.name in the condition.

See here for more info:

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-issues/

Amit Bansal_mz9tfs

Thanks Hana....Tried it too earlier but it also did not work.

Hana Kučerová

Hi @Amit Bansal ,

I've just tested it and it works for me:

{{#lookupIssues}}
{{#if(not(equals(status.name,"New")))}}
{{status.name}}
{{/}}
{{/}}

The problem could be in the status name - CANCELLED is not the same as Cancelled. So if your status is called Cancelled (not CANCELLED), your condition won't work.

Maybe it will be the best to use status.id in the condition instead of name.

Amit Bansal_mz9tfs

It worked. Thank you so much.

Amit Bansal_mz9tfs

Hana - While I am trying to use "and" operator, it is giving me an error (row 2). Would be of big help if you know the fix.

{{#lookupIssues}}
{{#if(not(equals(and(status.name,"Cancelled"),(status.name,"Invalid"))))}}
{{issueType.name}} - <{{url}}|{{key}}> - _{{summary}}_ {{status.name}} is due on {{dueDate}}.
{{/}}
{{/}}

Thanks,

Amit

Hana Kučerová

Hi @Amit Bansal ,

please try:

{{#if(and(not(equals(status.name,"Cancelled")),not(equals(status.name,"Invalid"))))}}

Amit Bansal_mz9tfs

It worked...Thanks a ton.

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud