ai-agents-metadata-filter-or-using-metadatafilters-with-multiple-filters-and-fi-545ff3cc

THEN Instead of relying on FilterCondition.OR, perform separate queries for each filter and merge the resulting nodes. Alternatively, check that the vector store's filter implementation correctly handles OR conditions; consider using a single filter with multiple values if applicable.

# Instead of:
# query_engine = index.as_query_engine(filters=MetadataFilters(filters=[...], condition=FilterCondition.OR))
# Do:
node_sets = []
for f in [MetadataFilter(key="color", value="red"), MetadataFilter(key="alpha", value="1")]:
    engine = index.as_query_engine(filters=MetadataFilters(filters=[f]))
    nodes = engine.retrieve("query")
    node_sets.extend(nodes)
# Deduplicate if needed