Assistance with Combined Filters in Databricks Vector Store Index

[kanks987]

Hi,

I’m working with the Databricks vector store index and need to apply combined filters to retrieve chunks that meet specific criteria.

My index contains the following columns: product_category, product_date, and description.

Question 1: How can I retrieve all chunks that meet this filter criteria:

• Product category is either:
  • Category 1 with dates from 2015-2016, or
  • All products from Category 2?

Question 2: How can I filter to get only those chunks where the description contains both term1 and term2?

I would appreciate a prompt response.

Helpful links: Databricks API Documentation

Thank you!