Queries with ticket status does not work properly

Margaux Jousse October 7, 2024

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

3 answers

1 accepted

0 votes
Answer accepted
Purnendu Chavan October 16, 2024

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

Margaux Jousse October 17, 2024

Wonderful it is working thank you !

Purnendu Chavan October 21, 2024

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

0 votes
Margaux Jousse October 16, 2024

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 October 16, 2024

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)

0 votes
Purnendu Chavan October 7, 2024

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

Thanks!!

Margaux Jousse October 7, 2024

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 October 7, 2024

Capture.PNG

Margaux Jousse October 9, 2024

Hello @Purnendu Chavan 

 

Any idea that might help please ? 

 

Thanks, 

Margaux 

Purnendu Chavan October 16, 2024

Hello Margaux,

try this queries

-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

Suggest an answer

Log in or Sign up to answer