db.collection.find()
call or a db.collection.aggregate()
call. Here’s how your JSON object is mapped and sent to MongoDB:db
collection
collection
key in your query objectquery
query
key in your query objectprojection
fields
key in your query object.sort() method
sort
key in your query object.skip() method
skip
key in your query object.limit() method
limit
key in your query objectdb.collection.count()
methodcount
key with any value in your query object$humanTime
function is also needed when using Query Parameters of type Date or Date/Time with MongoDB.$humanTime
object: {{param}}
becomes {"$humanTime": "{{param}} 00:00"}
(the 00:00 suffix is needed only with Date parameters, skip for Date Time parameters).Sort exceeded memory limit of 104857600 bytes, but did not opt in to external sorting. Aborting operation. Pass allowDiskUse:true to opt in.
allowDiskUse
option to write data to a temporary files for sorting.allowDiskUse
option, just add the option to your query: