Load document creation time field in Mongo DB from pipeline

asked 2019-11-22 01:05:23 -0600

bhanvi gravatar image

We need to add a field 'doc_creationtime' in "yyyy-mm-ddTHH:mm:ss.SSSZ" date or string format into every document inserted into MongoDb collection using pipeline. The date value should not be calculated in pipeline stages. It should be fetched from the Mongo DB at the exact time when the document is getting inserted in Mongo DB

As our requirement is to get the dcoument creation time till milliseconds, obtaining document creation time from 'Object_Id' in MongoDb cannot be used since its contains the dcoument creation time only till seconds.

we are already using the below to calculate the time, the record passes through the pipeline and assign to field 'docfetchedtime' ${time:extractStringFromDateTZ(time:now(), 'GMT', "yyyy-MM-dd'T'HH:mm:ss.SSS+00:00")}

The over all requirement is to get the differnce between document creation time in Mongo DB and the above calculated 'docfetchedtime' to get to know how much time pipeline is taking to fetch and load one document

edit retag flag offensive close merge delete