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

Queries with ticket status does not work properly

Margaux Jousse

Hello Community,

I'm trying to filter my several tickets and one part of my filter is using ths status of the ticket.

However I have one ticket that is appearing in both scenarios but it is not possible. The ticket is currently closed and is appearing with the 2 filters below :

- "AND status not in (Closed)" : which is not OK because the ticket is closed.

- AND status in (Closed) : which is ok because the ticket is closed, however it was already appearing with this filter even while not closed.

Could you please help me understand what is going on here ?

Thanks in advance,

Margaux

Accepted answers

Purnendu Chavan

Hello Margaux,

try this queries

I added brackets

-(type = "Web Contrib" AND "Sub Issue Type" = "Text/translation fix" AND "Hermès Métier(s)" is not EMPTY AND labels = WEBC OR labels =DTW) AND statusCategory NOT IN (Done)

-(type = "Web Contrib" AND "Sub Issue Type" = "Text/translation fix" AND "Hermès Métier(s)" is not EMPTY AND labels = WEBC OR labels =DTW) AND statusCategory IN (Done)

Thanks

All comments

Purnendu Chavan

Hi @Margaux Jousse
Can you please share the whole query?
Also, please share the screen shot of the workflow.

Thanks!!

Margaux Jousse

Hello,

Thanks.

Yes sure, please see below :

- type = "Web Contrib" AND "Sub Issue Type" = "Text/translation fix" AND "Hermès Métier(s)" is not EMPTY AND labels = WEBC OR labels =DTW AND status not in (Closed)

-type = "Web Contrib" AND "Sub Issue Type" = "Text/translation fix" AND "Hermès Métier(s)" is not EMPTY AND labels = WEBC OR labels =DTW AND status in (Closed)

Thank you !

Margaux Jousse

Hello @Purnendu Chavan

Any idea that might help please ?

Thanks,

Margaux

Margaux Jousse

Hello,

It is not working, when I'm using Done instead of Closed I have 2 more tickets closed appearing when it should not.

Best,

Margaux

Purnendu Chavan

Hello Margaux,

try this queries

I added brackets

-(type = "Web Contrib" AND "Sub Issue Type" = "Text/translation fix" AND "Hermès Métier(s)" is not EMPTY AND labels = WEBC OR labels =DTW) AND statusCategory NOT IN (Done)

-(type = "Web Contrib" AND "Sub Issue Type" = "Text/translation fix" AND "Hermès Métier(s)" is not EMPTY AND labels = WEBC OR labels =DTW) AND statusCategory IN (Done)

Thanks

Purnendu Chavan

Hello

Try this query

I added brackets

-(type = "Web Contrib" AND "Sub Issue Type" = "Text/translation fix" AND "Hermès Métier(s)" is not EMPTY AND labels = WEBC OR labels =DTW) AND statusCategory NOT IN (Done)

-(type = "Web Contrib" AND "Sub Issue Type" = "Text/translation fix" AND "Hermès Métier(s)" is not EMPTY AND labels = WEBC OR labels =DTW) AND statusCategory IN (Done)

Margaux Jousse

Wonderful it is working thank you !

Purnendu Chavan

Hi @Margaux Jousse ,
If the solution is good, please accept the answer.
Thank you !!

Welcome!

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

Quick Links

Find more posts tagged with

jira

filter

query

unknown-hosting-type

jira-unknown-hosting-type