B4J Question MONGO DateField

[alienhunter]

Hi To All
how to add a date filed in mongo instead of a string date ?

                    jobs.Insert(Array(CreateMap("machineid": portmachine,"machinename": namemachine, _
                        "machinedate": DateTime.Now ,"machinehour":hourstring1,"speedover":speedoverride,"feedover":feedoverride,"rapidover":rapidoverride, _
                        "actualspeed":actspeed,"actualfeed":actfeed)))

thank you very much Alfred

 

[Erel]

It being a while since I developed with MongoDB...

What is jobs? Are you using the RDC equivalent framework?

 

[alienhunter]

Hi Erel
jobs is the Collection (table)
"db.example.insert({"date":ISODate("2016-03-03T08:00:00.000")});"
sorry i do not know how send this ISO stuff

    mongo.Initialize("", "mongodb://10.0.2.7")
    poolconnection
    db = mongo.GetDatabase("ias")
    momgolist.Initialize
'
    jobs = db.GetCollection(jonbrstr)
    jobs.CreateIndex(CreateMap("machineid": 1))

note: this mongo stuff if awsome i love it how it works in b4x
thank you

 

[Erel]

Try this:

Sub CreateJavaDate(Ticks As Long) As Object
 Dim jo As JavaObject
 jo.InitializeNewInstance("java.util.Date", Array(Ticks))
 Return jo
End Sub

... "machinedate": CreateJavaDate(DateTime.Now)

 

[alienhunter]

Thank you very much Erel
This is awesome , this worked
the field is a Date
Alfred