Is there a way to query documents that aren’t referenced by another type of document?

Is there a way to query documents that aren’t referenced by another type of document? I’m trying to delete documents that aren’t being referenced.

The closest I’ve got to working out which documents don’t have a reference is this

Ideally I’d want a list of

_ids

of the documents that need removing

Found the solution from an old script I think had sent me to remove assets that were not being used. No idea how this query works or what it is doing but it brings me back the IDs I want to delete.

ah that's handy thanks, a quick explication how it works
1. fetch all documents of type offer

2. include _id and and refs (refs containing count of references)

3. filter results to only show data where refs count == 0 and then return only the id

Thank you for taking the time to explain 🙂