How do I correctly apply a metadata filter in Supabase Vector Store without conflicts?

Below is some guidance on resolving this issue:

What's Happening

The error

cannot provide both filter and this.filter

indicates that two filters are being passed to the Supabase query. In the Supabase Vector Store node, you only need to provide a filter via the Metadata Filter parameter. When another filter value is being set (for example, one coming automatically from a previous node or from an expression), the node ends up sending both a base filter and your custom metadata filter. This results in the conflict you’re seeing.

How to Resolve

1. Review Node Settings
   Make sure that you have not inadvertently provided a filter in more than one way. Use the Metadata Filter exclusively. Double-check that:

   • There aren’t any expressions or incoming values that add a separate filter.
   • The AI Agent node (or any preceding node) is not automatically passing along its own filter value.

2. Use the Metadata Filter Correctly
   According to the documentation, the Metadata Filter is designed to work as an AND query on the metadata fields. This means you only supply the metadata you'd like to match. Remove any additional filter configuration that might be set elsewhere in your workflow.

3. Reconfigure Your Workflow

   • If you’re using Take from previous node automatically for the prompt or filters, consider switching to Define below so that you can manually control the filter input.
   • Ensure that the metadata filter is the only filter being provided to the Supabase Vector Store node.

By making these adjustments, you should limit the query to only one filter, and that resolves the conflict error.

Final Note

Always check both the node settings and any data passed in from previous nodes so that you aren’t unintentionally merging filters. This is the recommended approach to search only within the specific metadata without encountering the error.