Supabase Retrieve Documents as Vector Store. Metadata filter not working?

Supabase Retrieve Documents as Vector Store. Metadata filter not working?

I am working on a Slack chatbot. I am using Supabase to store the chats and the documents. I added a field to the metadata called: “thread_ts” this adds the corresponding time stamp. So you can have different threads in Slack working with the AI Agent node. When the “Slack Trigger” node is triggered a thread_ts value is sent with it. Now I only want the corresponding documents and chats be retrieved by the AI Agent.

I use this flow: AI Agent - Tool - Answer and Questions with Vector store - Supabase Vector Store.
In the “Supabase Vector Store” node there is a “Metadata Filter” I add a field name and then i need to enter an expression to get the corresponding thread_ts. However there is no input in this node. So how would I be able to put that value in there? I tried a few basic expressions like: “{{$json.thread_ts ? $json.thread_ts : $json.ts}}” but it gives me an empty array as a result.

Please share your workflow

Share the output returned by the last node

no output.

Information on your n8n setup

  • n8n version: 1.114.0
  • Database: Supabase
  • n8n EXECUTIONS_PROCESS setting default:
  • Running n8n via n8n cloud
  • Operating system: Windows 11

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.