The problem is with these two fields : Relative Time(h:min:s.ms)
and Real time(h:min:s.ms)
The values cannot be retrieved While trying to export the collection to csv/json. So I tried the following:
- full query, able to get the values for both fields.
> db.cell19L28A.find()
{ "_id" : ObjectId("62be726ae6168c39e037bdd5"), "State" : "Rest", "Jump" : 1, "Cycle" : 1, "Steps" : 1, "Current(A)" : 0, "Voltage(V)" : 3.3965, "Capacity(Ah)" : 0, "Energy(Wh)" : 0, "Relative Time(h:min:s.ms)" : "0:00:00.000", "Real time(h:min:s.ms)" : "2022-07-01 09:30:46", "Process Name" : "Charge.xml", "Start Time" : "2022-07-01 09:30:46" }
- able to get the values with _id = 0
> db.cell19L28A.find({},{"_id":0})
{ "State" : "Rest", "Jump" : 1, "Cycle" : 1, "Steps" : 1, "Current(A)" : 0, "Voltage(V)" : 3.3965, "Capacity(Ah)" : 0, "Energy(Wh)" : 0, "Relative Time(h:min:s.ms)" : "0:00:00.000", "Real time(h:min:s.ms)" : "2022-07-01 09:30:46", "Process Name" : "Charge.xml", "Start Time" : "2022-07-01 09:30:46" }
- But when tried with 1 for both of those fields, an empty string is returned.
> db.cell19L28A.find({},{"_id":0,"Relative Time(h:min:s.ms)":1,"Real time(h:min:s.ms)":1})
{ }
{ }
{ }
- able to get the values when given 0 for all the rest of the fields.
> db.cell19L28A.find({},{ "_id" : 0, "State" : 0, "Jump" : 0, "Cycle" : 0, "Steps" : 0, "Current(A)" : 0, "Voltage(V)" : 0, "Capacity(Ah)" : 0, "Energy(Wh)" : 0, "Process Name" : 0, "Start Time" :0 })
{ "Relative Time(h:min:s.ms)" : "0:00:00.000", "Real time(h:min:s.ms)" : "2022-07-01 09:30:46" }
Can someone please help me understand what is going on here!