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

JQL Automation for Past Due Date Not working...

ayoung

Hi there,

I am attempting to pull records that match:

Due more than 30 days ago
Does not have the label "Post_Survey"
Status = Done

I am continuing to get 0 records returned on tests though I specifically set up the attached ticket to match all criteria. Anyone see something I messed up here?

Screen cap included to demonstrate

Accepted answers

Mikael Sandberg

It is because you are searching on labels. When you do that you either have to include issues that do not have a label like this:

duedate < -30d AND (labels != Post_Survey OR Labels is EMPTY) AND resolution was "done"

The other option is to negate the label like this:

duedate < -30d AND NOT (labels = Post_Survey) AND resolution was "done"

All comments

Mikael Sandberg

It is because you are searching on labels. When you do that you either have to include issues that do not have a label like this:

duedate < -30d AND (labels != Post_Survey OR Labels is EMPTY) AND resolution was "done"

The other option is to negate the label like this:

duedate < -30d AND NOT (labels = Post_Survey) AND resolution was "done"

ayoung

You are a complete rock star Mikael! Thank you so much - I never knew this field was handled different in JQL Automation scripts Found exactly one issue as it should. Amazing!

Mikael Sandberg

It is not just in automations that you have to do this. Anytime you are doing a JQL that you want to exclude a label or component from you have to include when the label/component is empty.

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jql

automation

jira-service-management-cloud

jira-service-management