MongoDB: How to query over a json string?

Question

There's a MongoDB collection that was populated with documents like this one:

{
    "_id" : ObjectId("5b7f83b591fae49715443590"),
    "content" : "{\n\t\"email\":\"[email protected]\",\n\t\"country_code\": \"US\"\n}"
}

As you can see "content"has a JSON string

I was able to parse the string using JSON.parse() like:

db.getCollection('my_collection').find({}).map(function(doc){ return {'_id':doc._id, 'content': JSON.parse(doc.content)}});

Giving me an array of objects with _id and content as an object.

Is there a way to execute queries (filtering, aggregate functions) over content preferably without getting an array from map?

Ariel Henryson · Accepted Answer · 2018-08-24 05:52:33Z

2

like you said In terms of the database content is a string. So you need to save the entire collection where content will be a object so you will be able to filtering, aggregate etc...

answered Aug 24, 2018 at 5:52

Ariel Henryson

1,3561 gold badge10 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MongoDB: How to query over a json string?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related