Groq query to exclude items from an array within a document type in Sanity

hey, hoping someone can give me a hand with something that i feel should be really simple but I just cant get it to work!I have a type called 'press' and then a type called 'pressFeatured' which has an array within it of references to press items.
I want to do a groq query to get back all the press items not including the ones in this featured array. I have tried this:

*[_type == 'press' && references(*[_type == 'pressFeatured' && featured[]._ref != ^.id])]

but it just returns all of the press articles, including the featured one! Anyone got any ideas?

I think you want

!(^.id in featured[].ref])

Hey , thanks for getting back to me! I've just tried

*[_type == 'press' && references(*[_type == 'pressFeatured' && !(^.id in featured[].ref)])]

but it returns no results? Am I missing something?

Hm, I had a typo, you need

_ref

. But that might not be why.

ah sorry, I completely missed that 🤦

*[_type == 'press' && references(*[_type == 'pressFeatured' && !(^._id in featured[]._ref)])]

added the underscores to if and ref, but still no results when I'm expecting 154

Hm, I’m not sure, then. If you give me your project ID and dataset name, I can test myself.

Course, I'll dm you

Do you have an example of a document of type

press

that references a

pressFeatured

document?

No sorry its the other way round, so pressFeatured references press documents

references()

works on the document you are filtering. So your query above means “where type is ‘press’ and it references some other documents”.

I’m not sure what you want, then, given your correction. What do this mean:

I want to do a groq query to get back all the press items not including the ones in this featured array.

Is there more than one

pressFeatured

document?

Sorry, I must of explained it badly! So I am trying to get back an array of

_type == 'press'

without any that are listed as featured in the document

pressFeatured.

There is only one document called

pressFeatured

with the array of featured items within it, and there will only ever be 1 of these documents.

Ok, then I think you want to something like:

That gave me this error, but I changed it round to be

*[_type == 'press' && !(_id in *[_type == 'pressFeatured'][0].featured[]._ref)]

and it worked perfectly! thank you!

D’oh, I’ve been doing too much SQL lately. Yes, that’s it. 👍