how can i find text search in an array in mongodb

Question

 {
    "_id":objectId(23651478),
    "name":"Tomatos"
    "array":[
             {"title":"Vegetables"}
            ]
    "description":"Vegitables are good to health"
 },
 {
    "_id":objectId(45761244),
    "name":"Apples"
    "array":[
             {"title":"Fruits"}
            ]
    "description":"Fruits are good to health, vegitables are also good to health"
 },
 {
    "_id":objectId(45761244),
    "name":"Apples"
    "array":[
             {"title":"Vegetables-home-made"}
            ]
    "description":"Fruits are good to health, vegitables are also good to health"
 }

Above is my mongo schema modal for my project requirement. When I want to search for vegetables only, vegetable name should have to come. If I search for both vegetables and fruits, both names ie., Tomato and Apple should have to come.

I used "$in" operator like this

{"array":{$in:[{"title":"Vegetables"},{"title":"Fruits"}]}}

It is giving only documents that have the title Vegetables and not the Vegetables-Home-made. For that I tried to use $elemMatch

 {"array":{$elemMatch:[{"title":"Vegetables"},{"title":"Fruits"}]}}

But when we search for multiples ie., Vegetables and Fruits in elemMatch, it is giving an error, I want a text search in a array for particular title key only ie.,

{"array":{$text:{:$search:[{"title":"Vegetables"},{"title":"Fruits"}]}}}

you can use regular expression $regex or $text. try this : {"array":{$in:[{"title": { $regex:{/Vegetables/}}]}} — chirag
– chirag, Commented Oct 12, 2016 at 11:28

chirag · Accepted Answer · 2016-10-12 11:54:57Z

3

here is what you want:

you can use regular expression within $in operator like this :

{array: { $elemMatch: { title: { $in: [/Vegetables/, /Fruits/] }}}}

edited Oct 12, 2016 at 11:54

answered Oct 12, 2016 at 11:49

chirag

1,7792 gold badges18 silver badges33 bronze badges

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

Comments

Rotem · Accepted Answer · 2016-10-12 11:30:37Z

0

The general text search in MongoDB looks like that:

db.collectionName.find( { $text: { $search: "Vegetables" } } )

Please check the search text you are running the word Vegetables contains a spelling error in it:

{"array":{$text:{:$search:[{"title":"Vegitables"},{"title":"Fruits"}]}}}

answered Oct 12, 2016 at 11:30

Rotem

1,3891 gold badge11 silver badges24 bronze badges

1 Comment

Daniel Viglione Over a year ago

This requires a text index.

Collectives™ on Stack Overflow

how can i find text search in an array in mongodb

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related