title: how to make mongodb aggregate with $in, $or $and
body: <p><strong>Here is Query in mongodb , where i used to get information on the basis of status, verify_status and their category as well as their Location, their is only one location for the field but need to find in multiple set of location.</strong></p>
  <p><strong>Update : I try to run this query in Robo3t , it return blank Result but same query i run in Studio3t it shows expected Result. is there any version issue.</strong></p>
  <pre><code>{
      &quot;status&quot;:{
          &quot;$eq&quot;:&quot;Active&quot;
      },
      &quot;verify_status&quot;:{
          &quot;$eq&quot;:&quot;Yes&quot;
      },
      &quot;$or&quot;:[
      {
          &quot;category&quot;:{
              &quot;$eq&quot;:{
                  &quot;$oid&quot;: &quot;5da0f71e15712b5f7723bb58&quot;
              }
          }
      },
      {
          &quot;multi_car_status&quot;:{
  
              &quot;$eq&quot;:&quot;ON&quot;
  
          },
          &quot;additional_category&quot;:{
  
              &quot;$eq&quot;: &quot;5da0f71e15712b5f7723bb58&quot;
  
          }
      }
      ],
      &quot;driver_location&quot;:{
          &quot;$in&quot;:[
              &quot;5dee787f15712b443f6a5e06&quot;,
  
              &quot;5dee787f15712b443f6a5e06&quot;
          ]
      }
  }
  </code></pre>
  <p><strong>When i removed the driver_location or &quot;$or&quot; its return resul.there are
  result in the db but it return return 0 result. i can't get the result with the both the operators. below is the sample data.</strong></p>
  <pre><code>{
      &quot;_id&quot; : ObjectId(&quot;5ead0f5f15712b5df22d7e23&quot;),
  
      &quot;driver_location&quot; : &quot;5dee787f15712b443f6a5e06&quot;,
  
      &quot;category&quot; : ObjectId(&quot;5da0f71e15712b5f7723bb58&quot;),
  
      &quot;image&quot; : &quot;7f8e1ddfbe862a7ac4386b2f41fe953f.jpg&quot;,
  
      &quot;driver_name&quot; : &quot;Ravi aa&quot;,
  
      &quot;email&quot; : &quot;#####@gmail.com&quot;,
  
      &quot;dail_code&quot; : &quot;+1&quot;,
  
      &quot;mobile_number&quot; : &quot;83748746&quot;,
  
      &quot;dob&quot; : &quot;10/05/2000&quot;,
  
      &quot;password&quot; : &quot;######&quot;,
  
      &quot;verify_status&quot; : &quot;Yes&quot;,
  
      &quot;status&quot; : &quot;Active&quot;,
  
      &quot;availability&quot; : &quot;Yes&quot;,
  
      &quot;mode&quot; : &quot;Available&quot;,
  
      &quot;gender&quot; : &quot;male&quot;,
  
      &quot;vehicle_type&quot; : null,
  
      &quot;vehicle_maker&quot; : &quot;5da0f05115712b5fb36e3d02&quot;,
  
      &quot;vehicle_model&quot; : &quot;5db22e1215712b25a36b8a3c&quot;,
     
     
      &quot;loc&quot; : {
          &quot;lon&quot; : 77.35124777,
          &quot;lat&quot; : 28.6543715
      },
      &quot;address&quot; : {
          &quot;address&quot; : &quot;delhi&quot;,
          &quot;county&quot; : &quot;United States&quot;,
          &quot;state&quot; : &quot;AR&quot;,
          &quot;city&quot; : &quot;delhi&quot;,
          &quot;postal_code&quot; : &quot;122001&quot;
      },
      &quot;multi_car_status&quot; : &quot;ON&quot;,
      &quot;additional_category&quot; : [ 
          &quot;5da09ed315712b413333ca58&quot;,
   
          &quot;5da0f6fc15712b5c1956eed6&quot;, 
  
          &quot;5da0f73b15712b5fb36e3d09&quot;
      ],
     
     
  }
  </code></pre>