I’m building a Q&A workflow using n8n with a Vector Store Retriever connected to Postgres PGVector. The user sends a JSON payload from the frontend with the following structure: { "question": "Is Benito Juárez's birthday considered a non-working day?", "collection": "1952708", "category_id":…

Hi @merarisosa Welcome to the community! I think this happens because you are joining the array of category_id’s into a comma separated string. This results in a query for documents with a category:'category1,category2' => empty response. If I remember correctly to achieve a combination of filter…

Hi! @Ventsislav_Minev Thank u for u reply. I already tried just passing the array [imagen] i passed it to the pgvector store retriever but it didnt work as expected [imagen] It seems like the PGVector Store is ignoring the filter. I tried asking something that is not contained in the array I …

How to filter multiple metadata values in a Vector Store Retriever PGvector node?

Questions

merarisosa April 3, 2025, 5:24pm 4

Well, at the end i changed PG Vector store, and i prefered to use Qdrant, it has a search filter where you just add a json code to filter data

Topic		Replies	Views
Multiple entries in supabase vector store metadata filter Questions	4	1226	December 6, 2024
How can I apply metadata filtering (multi-faceted filtering) in the Milvus Vector Store “Tool for AI Agent” mode? Questions rag	2	134	March 1, 2026
Empty array filtering metadata in Supabase vector Questions	3	206	November 27, 2025
Vector store metadata filtering - no access to variables Questions node , langchain	5	1449	January 31, 2024
N8n pgvector Metadata Filter allowing $gt $gte $lt $lte operators Questions	2	128	December 4, 2025

How to filter multiple metadata values in a Vector Store Retriever PGvector node?

Related topics