"not in" filtering is not working.

[bldev2473]

Hi, I'd like to use the pre-filtering feature. I'm using VectorRetriever.
pre-filters

But following error occurred.

neo4j.exceptions.CypherSyntaxError: {code: Neo.ClientError.Statement.SyntaxError} {message: Invalid input 'NOT': expected an expression or ')' (line 1, column 131 (offset: 130))
"MATCH (node:`Chunk`) WHERE node.`embedding` IS NOT NULL AND size(node.`embedding`) = toInteger($embedding_dimension) AND (node.id NOT IN $param_0) WITH node, vector.similarity.cosine(node.`embedding`, $query_vector) AS score ORDER BY score DESC LIMIT $top_k RETURN node {.id, .text, .content_id} AS node, labels(node) AS nodeLabels, elementId(node) AS elementId, elementId(node) AS id, score"

My implementation is:

filters ={
    "id": {
        "$nin": docIds # list of strings
    }
retriever_result = retriever.search(query_text=query_text, filters=filters)

I think WHERE NOT thing IN list not WHERE thing NOT IN list is the correct syntax.
It seems that the current version of _single_condition_cypher() function in filters.py can't handle this.

def _single_condition_cypher(
    field: str,
    native_operator_class: Type[Operator],
    value: Any,
    param_store: ParameterStore,
    node_alias: str = DEFAULT_NODE_ALIAS,
) -> str:
    native_op = native_operator_class(node_alias=node_alias)
    param_name = param_store.add(native_op.cleaned_value(value))
    query_snippet = f"{native_op.lhs(field)} {native_op.CYPHER_OPERATOR} ${param_name}"
    return query_snippet

[stellasia]

Hi @bldev2473 ,

Thank you for raising this issue. A fix has just been merged and will be part of the next release.

[stellasia]

1.7.0 has just been released, with the fix, so closing this issue now.