How to add state variable in the Pinecone Metadata Filter?

[ROOT0750]

I have developed a furniture-related chatbot using Flowise, integrated with Pinecone as the vector database. The chatbot retrieves the top 3 product recommendations based on customer queries. However, when customers request additional products, the chatbot currently repeats the previous recommendations, which is not ideal.

Objective: To enhance the chatbot's functionality by dynamically excluding previously recommended products from subsequent recommendations using Pinecone's metadata filtering.

Current Approach:

1. Tracking Recommended Products:
   - After each query, the chatbot stores the product IDs of the top 3 recommended products in a state variable.

2. Implementing Metadata Filter:
   - The goal is to construct a dynamic metadata filter that excludes these stored product IDs in subsequent queries.
   - For instance, if the metadata field for product IDs is product_id, the filter would be:
   {"product_id": {"$nin": [id1, id2, id3]}}
   

Challenge: The main challenge lies in dynamically passing the list of product IDs stored in the state variable to the Pinecone metadata filter within Flowise.