Check if a value exists in array using aggregation

Question

I'm using mongoDB version 3.2. and i want to check if a string is exist in an array of string, i want to use the regex so if just a part of the given string is exist in a string in the array, that record should be returned. here's an example of a record:

{
    name: "initiative 1",
    portfolioItems: ["Non clinical", "ITS portfolio", "Lean"]
}

the following query does not work:

db.collection.aggregate([
    {
        $match:
            { 'portfolioItems' : { $in: [/term/] } }
    }
])

is there anyway to achieve that ?

Ashwanth Madhav · Accepted Answer · 2019-03-18 09:47:02Z

1

Try this one.

db.collection.aggregate([
{
    $match:
    {"portfolioItems":{'$regex':"^it", '$options': 'i'}}
}
])

The symbol ^ used to start from the first of string. If u don't need it. You can remove it.

Your query become

 {
    $match:
    {"portfolioItems":{'$regex':"^"+term, '$options': 'i'}}
}

answered Mar 18, 2019 at 9:47

Ashwanth Madhav

1,2341 gold badge12 silver badges23 bronze badges

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

3 Comments

Ayoub k Over a year ago

still the query return no results.

Ashwanth Madhav Over a year ago

I run the same in my local using Robo3T and worked fine.

Ayoub k Over a year ago

yes it works fine on shell too. bug in my node app didn't work !!

ASK · Accepted Answer · 2019-03-18 09:08:46Z

0

You have to match the pattern in each element of array. Try this :

{ 'portfolioItems' : { $regex: [/term/] } }

answered Mar 18, 2019 at 9:08

ASK

1,2741 gold badge11 silver badges14 bronze badges

4 Comments

ASK Over a year ago

But there is no element which contains "term", so results will be empty. Have you tried another element.

Ashwanth Madhav Over a year ago

{ $match: {"portfolioItems":{'$regex':"^it", '$options': 'i'}} } Try with this

Ashwanth Madhav Over a year ago

term is javascript variable used to store the search term. + used to concatenate with ^. It is not a static string like "term" that you entered in the comment.

ASK Over a year ago

Thank you very much for informing me. I didn't have much idea about this

Collectives™ on Stack Overflow

Check if a value exists in array using aggregation

2 Answers 2

3 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related