Where params don't allow to specify NOT clause or equals to undefined / null.

[1pxone]

Tried to accomplish smth like this:

findRelationships({
    alias: 'Projects',
    where: {
        source: {
            id: id,
        },
        target: {
            deleted: null, // undefined or smth
        },
    },
    session: transaction,
}

Here I needed to fetch all Projects without deleted property. When Project is being deleted it gets ISO8601 string set into deleted property.

Are there any workarounds to solve this? (except raw cypher)
Thanks!

[1pxone]

Equivalent cypher would be

MATCH (o:Organization { id: $id })-[:CONTAINS]->(p:Project)
WHERE p.deleted IS null
RETURN collect(DISTINCT p) as projects

[themetalfleece]

Hey, thanks for creating this issue!
Right now there is no support for null, but it should be, so it'll be one of the things I work on next. I'll keep you posted.