Mango search in Arrays

by

First, you need to create your index. I suggest that you create an index on the Calibration.Presettings.Date field.

You can use the following JSON object to create it:

{
  "index": {
    "fields": [
      "_id",
      "Calibration.Presettings.Date.[].Type"
    ]
  },
  "type": "json"
}

So the selector would be like this :

{
  "selector": {
    "Calibration.Presettings.Date": {
      "$elemMatch": {
        "$and": [
          {
            "Type": "generated"
          },
          {
            "Value": {
              "$gte": "2016-09-01"
            }
          }
        ]
      }
    }
  }
}

We execute the query on the field Calibration.Pressettings.Date which is an Array. Since it’s an array, we have to use the $elemMatch operator.

Then, we have a $and condition for the Value and the Type.

The Type of the Date has to be generated. With can either use the $eq operator or simply use this simple syntax: {"field":"value"}.

Finally, the Date`s Value must be greater or equal to X date. We can use the $gte operator.

More Related Contents:

  1. Please help me access nested array
  2. remove an index number from array
  3. Reading output of a command into an array in Bash
  4. Passing arrays as parameters in bash
  5. Creating an Array from a Range in VBA
  6. Element-wise array replication in Matlab
  7. Select the values of one property on all objects of an array in PowerShell
  8. Iterate over two arrays simultaneously in bash
  9. What is the ideal growth rate for a dynamically allocated array?
  10. Two-dimensional array in Swift
  11. How to iterate over array of objects in Handlebars?
  12. 1D Number Array Clustering
  13. Creating Indicator Matrix
  14. How to initialize two-dimensional arrays in Fortran
  15. Array of Matrices in MATLAB
  16. Why have arrays in Go?
  17. Print array elements on separate lines in Bash?
  18. Swift 3 2d array of Int
  19. How to get a list of registered route paths in Laravel?
  20. How is the array stored in memory?
  21. Incrementing: x++ vs x += 1
  22. A data structure supporting O(1) random access and worst-case O(1) append?
  23. Defining array with multiple types in TypeScript
  24. Swift 4 JSON Codable – value returned is sometimes an object, others an array
  25. Regarding in-place merge in an array
  26. MongoDB: find and findOne with nested array filtering
  27. How can I convert array to string in hive sql?
  28. Operation on an array of structs implementing Equatable
  29. How to copy an array in Bash?
  30. ReDim Preserve “Subscript Out of Range”

Leave a Comment