Problem querying MongoDB


#1

Hi!

I feel like I’m the problem here, but I can’t find any information to help me.

Let’s say I have a MongoDB object that looks like this:

{
“foo:”:“bar”,
“bar”: {
“boo”: 0,
“far”: “boo”
}
}

I want to get all the object where “boo” is 0. I also want to be returned the “boo” field and not the “bar” field. Directly in Mongo, you can use “bar.boo” to access boo. However, it doesn’t seem to work on redash. Any way I can do that?

Thanks.


#2

hi
try this
{
“collection”: “nameofcollection”,
“query”: { “boo”: 0

},
"fields": {
    "boo": 1,
    
}

}