Posts

Showing posts with the label mongodb tips

MongoDB Tips - Using _id to determine when the object was inserted

MongoDB objectid conversion to timestamp Basically we can generate timestamp when this document is inserted by converting the objectid to timestamp: Please look at the following for javascript by  Steve Ridout  on his blog https://steveridout.github.io/mongo-object-time/ Why generate an ObjectId from a timestamp? To query documents by creation date. e.g. to find all comments created after 2013-11-01: db.comments.find({_id: {$gt: ObjectId("5272e0f00000000000000000")}}) Javascript functions var objectIdFromDate = function (date) { return Math.floor(date.getTime() / 1000).toString(16) + "0000000000000000"; }; var dateFromObjectId = function (objectId) { return new Date(parseInt(objectId.substring(0, 8), 16) * 1000); };

MongoDB Tips: Views

use <db>; This command will give you all view definition under the db you are in.  db.getCollectionInfos({type:'view'}); ex: {                 "name" : "utilizationSubcategoryNumbersOMD",                 "type" : "view",                 "options" : {                         "viewOn" : "utilizationSubcategoryNumbers",                         "pipeline" : [                                 {                                         "$match" : {                           ...