anyone know how I could perform a left join and find records without a matching record in the referenced collection? i know i can left join doing

id:* || $collection(id:*)

, but I basically want

id:* && not $collection(id:*)

(but thats not valid syntax obv)

cc @Harpreet Sangar

@Rob Bast In the latest RC build, you can mention

filter_by: !$collection(id:*)

to get all the documents that are not referenced in the collection.

We on cloud, so no RC

RCs are available on cloud in the versions from down menu.

ah, that's good to know.

We don't publish changelogs for RC builds. Looking at the commit history in the github versioned branch should give you an idea of the changes.

alright, thanks

Yes, the syntax is correct. Are you facing any issue?

i'm getting back all the records in our collection.. so I think I maybe misunderstand how I should use it

Can you share the schema of your collections and the query?

yeah, where/how would like to see them?

I would only need the relevant fields like the

reference

field and such. No need to provide the whole schema.

is a DM okay, or a github gist?

As you wish.