Query - ONLY show results

[Nick]

Hi,

Can anyone help me with adjust this query so that it INCLUDES ONLY those results where COMPONENT =XYZ.

In other words, if an item has COMPONENT = XYZ + ABC, it should NOT be shown?

This is my full query so far: "project = CC AND component = XYZ ORDER BY Rank"

Thanks in advance,

Z

[Nick]

Is anyone able to help!? Seems like a relatively straightforward question...

I just wanted items where ' COMPONENT = XYZ ' only

So if an item had NO components, or any components OTHER THAN XYZ (or as well as), they would not be returned. ONLY results that have COMPONENT = XYZ exclusively should be returned in the query...

[Pramodh M]

Hi @Nick 

Component in (XYZ) AND Component not in (ABC)

See if this works and let me know

Thanks,

Pramodh

[Nick]

Thanks, but I don't want it to be this or that, I want to include ONLY items where component = XYZ.

Items with ANY other components should be excluded...

Does it make sense?

[Nic Brough -Adaptavist-]

Add all the other components in the the "not" in Pramodh's query.  Component not in (ABC, DEF, GHI, etc)

[Nick]

Erm, that is one helluva query given we have over 100 components.....!!!!!!

[Pramodh M]

Yes, if you need to get the data, you need to add the Components in the query!!

[Nic Brough -Adaptavist-]

Yes, but there's no other way to do it directly.

Indirectly, if you could automate or script something that counts the components set on an issue and stores it (on potentially any change of the components list with create/edit/transition), your query could be "components = XYZ and component-count = 1"