Filter with must-not conditions

from actian_vectorai import VectorAIClient, FilterBuilder, Field
import random

# Connect to VectorAI DB server
with VectorAIClient("localhost:6574") as client:
    # Generate query vector
    query_vector = [random.gauss(0, 1) for _ in range(128)]
    
    # Filter: exclude electronics AND exclude expensive items (>= $100)
    filter = FilterBuilder()\
        .must_not(Field("category").eq("electronics"))\
        .must_not(Field("price").gte(100.0))\
        .build()
    
    # Search with filter
    results = client.points.search(
        "products",  # Collection name
        vector=query_vector,  # Query vector
        limit=10,  # Maximum results
        filter=filter  # Apply filter
    )
    
    # Display results
    for result in results:
        print(f"ID: {result.id}")
        print(f"Category: {result.payload['category']}")
        print(f"Price: ${result.payload['price']}")
        print("-" * 50)

import { VectorAIClient, FilterBuilder, Field } from '@actian/vectorai-client';

async function main() {
    // Connect to VectorAI DB server
    const client = new VectorAIClient('localhost:6574');

    // Generate query vector
    const queryVector = Array.from({ length: 128 }, () => Math.random() * 2 - 1);

    // Filter: exclude electronics AND exclude expensive items (>= $100)
    const filter = new FilterBuilder()
        .mustNot(new Field('category').eq('electronics'))
        .mustNot(new Field('price').gte(100.0))
        .build();

    // Search with filter
    const results = await client.points.search('products', queryVector, {
        filter: filter,
        limit: 10
    });

    // Display results
    for (const result of results) {
        console.log(`ID: ${result.id}`);
        console.log(`Category: ${result.payload.category}`);
        console.log(`Price: $${result.payload.price}`);
        console.log('-'.repeat(50));
    }
}

main().catch(console.error);