I have a Doc which a user can categorize as well as assign it to one or more buckets. What is the most effective way to search if any doc contains any of the values provided for one of these arrays.
For example categories Array looks like this categories: [ “CC”, “DL”, “HL”, “R” ] and Bucket array looks like this
bucket : [“Seller”, “Buyer”, “Investor”]
in my query ifor example would want to get all docs where categories contains DL and HL in array as well as bucket is Seller or Buyer