How to add multiple columns i.e. fieldnames in mongo index_overview and python code?

MongoDB Atlas Vector Search
,
2

Hey @Nithin_Reddy1 , great question! For any additional column you want to filter on, you can add it to the the "fields" list you have supplied similar to how you’ve already done company. See this link for an example.

For your case, it should look something akin to this:

{
   ...
   "fields": [
        {
            "numDimensions": 1536,
            "path": "embedding",
            "similarity": "cosine",
            "type": "vector",
        },
        {
            "path": "Company",
            "type": "filter",
        },
        {
            "path": "Date",
            "type": "filter",
        }
   ]
}

To query against this, your pre_filter query can leverage the $and operator

vectorstore_retriever_args["pre_filter"] = {"$and": [ {"Company": {"$eq": company}}, {"Date": {"$eq": date}}]}

For more eligible operators, check our documentation here on $vectorSearch.fields.