mongodb connector - criteria definition

Answers

• Options

  MichaelKnopf Administrator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 31 RM Data Scientist

  February 2015

  Hello Ines,
  
  The Read MongoDB operator allows to specify both a query criteria object and a projection object, as well as to limit the results.
  
  Thus, you should be able to reuse the JSON objects from your Robomongo query without further modifications.
  
  Relevant Read MongoDB parameters:
  
  mongodb instance: MyInstance
  collection: mycollection
  criteria:

  {
         time: {
               $gte: ISODate("2015-01-27T00:00:00.000Z"),
               $lt : ISODate("2015-01-28T00:00:00.000Z")                     
         },
         code: '200',
         path: {
              $regex: '/.*pdf*/'
         } 
  }

  projection:

  {
         path : 1,
         size : 1,
         _id : 0          
  }

  limit: 100
  skip: 0
  
  Note that limit and skip are expert parameters that might be hidden by default.
  
  You might also check out this Getting Started Guide that shows how to setup your MongoDB connection.
  
  Best,
  Michael

  1