Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: MongoDB and Date Search

  1. #1

    Default MongoDB and Date Search

    Hi I am also facing similar kind of issue

    My JSON query is (Mongo DB)
    { "timeStamp": { $gte: ISODate("2016-12-02T21:15:00.000+0000") },
    $and: [ { "timeStamp": { $lte: ISODate("2016-12-06T21:15:00.000+0000") } } ],
    "tag_id": { $ne: "Tag1} }
    '

    Tried following query also
    { "tag_id": "Tag1",
    "timeStamp": ISODate("2016-05-02T14:40:00.000+0000") }
    No result for above query as well

    Not able to get any data

    But when I use

    { "tag_id": "Tag1}

    I get the desired data.I have tried your solution also.No result.

    Kindly Support

  2. #2

    Default MongoDB and Date Searches

    Hey can you please share the example as I am also facing the similar issue.

    My query is { "tag_id": "Tag1", "timeStamp": ISODate("2016-05-02T14:40:00.000+0000") }

    which is working fine for


    { "tag_id": "Tag1}

    Thanks

  3. #3

    Default

    Hey I am also facing similar kind of issue in MongoDB JSON query

    My query given as
    { "tag_id": "Tag1",
    "timeStamp": ISODate("2016-05-02T14:40:00.000+0000") }

    Not getting any data for above query.


    But when I use


    { "tag_id": "Tag1}


    I get the desired data.

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.