Back to all

Searching for only orphaned notes

When using the "SearchQuery":

"SecAccess/Write": { "$EQ": "VXNlcgkq" }

For a particular database, I see this result (partial):

"Data": [{ "Key": "Tm90ZQkyNDgzNjc=", "ParentKey": null},{ "Key": "Tm90ZQkyMDg4NDg=", "ParentKey": null}}, ...] }

"VXNlcgkq" is the key for Public

But if "SearchQuery" is this:

"$AND": [{"SecAccess/Write": { "$EQ": "VXNlcgkq" }},{"ParentKey":{ "$EQ": null }}]

I see this:

"Data":[]

When searching for notes that don't have a ParentKey, using { "$EQ": null } is obviously not the correct approach.

What is the correct approach?