Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

I want filter issues except those issues has linked another specific type of issues.

Apsara Dissanayake December 21, 2022

I have 4 main type of issues.  assume it is "third party arrangement" and "third party process". 

relationship of this issue types are:1 to many.

Therefor it can be has many "third party process" for a "third party arrangement".

there are several third party processes defined in the system. it is defined as different third party process types.

I want to filter  "third party arrangement" type issues that dont have linked specific type of third party processes .

My Query is:

project=SNGOMT AND type=third party service arrangement AND NOT issueFunction in linkedIssuesOf(project=SNGOMT AND OutSourcing Process Type="MAS Annual Monitor")

 

My query getting error.

1 answer

0 votes
Trudy Claspill
Community Champion
December 22, 2022

Hello @Apsara Dissanayake 

What is the error that you get?

Apsara Dissanayake December 28, 2022

CD742FED-248C-4C81-B0B2-C0F864479F50.jpeg

Trudy Claspill
Community Champion
December 29, 2022

Hello @Apsara Dissanayake 

Where you have:

('outsource Process Type = MAS Annual Monitoring')

...you need to have:

("'outsource Process Type' = 'MAS Annual Monitoring'")

Multi-word field names and multi-word values need to be within quotation marks. And the entire subquery also needs to be within quotation marks. I have used double-quotes to surround the subquery, and single-quotes to surround the field name and the value.

Suggest an answer

Log in or Sign up to answer