Search code examples
jsonrmongolite

R -How to pass value in mongolite Query

I'm using mongolite package to connect and retrieve data from MongoDB.How to pass value in mongolite find query

##connecting mongodb

library(mongolite)

mongo<-mongolite::mongo(collection = "Sample", db = "Test", url = 
                          "mongodb://User:123@Wyyuyu:13333/ty2_U",verbose = TRUE)

## getting all data from collection data from collection below query is working fine.

values <- mongo$find()

## But I want to filter specific value by passing value.

 for(i in c("process","check","queue"))
{    

   values <- mongo$find('{"field" : i}',)
}

if I tried above code i'm getting getting below issues . please help me to resolve 

Error: Invalid JSON object: {"field" : i}
Solution

  • Given your i is a variable, you need to create the string using something like paste0: 

    values <- mongo$find(paste0('{"field" : ', i, '}') )

    but rather than a loop you could also use

    values <- mongo$find('{"field" : { "$in" : [ "process", "check", "queue" ] } }')