MongoDB get documents with at least one not empty array

Question

My schema:

    db.Interactives = mongoose.model(
        'Interactives',
        new Schema({
            url: String,
            forms: Array,
            inputs: Array,
            textareas: Array,
        })
    );

I want to find all documents where at least one array isnt empty, so I tried:

    await db.Interactives.find({
            $elemMatch: {
                forms: { $ne: [] },
                inputs: { $ne: [] },
                textarea: { $ne: [] },
            },
        })
            .select('-_id -__v')
            .exec()

How can I achieve this?

Zauberbutter · Accepted Answer · 2019-07-31 17:48:36Z

1

The issue with your code is that it is trying make sure no arrays are empty. The other issue is that $elemMatch searches elements of an array for a value. You don't want to do that, you want to compare the array with a blank array. The only change you have to make is replace $elemMatch with $or and add brackets like so

    await db.Interactives.find({
            $or: [
                {forms: { $ne: [] }},
                {inputs: { $ne: [] }},
                {textarea: { $ne: [] }},
            ]
        })
            .select('-_id -__v')
            .exec()

edited Jul 31, 2019 at 17:48

Zauberbutter

1,02211 silver badges32 bronze badges

answered Jul 31, 2019 at 15:45

Aidan

5044 silver badges24 bronze badges

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

Comments

MilanRegmi · Accepted Answer · 2019-07-31 17:39:55Z

What you missed is $or in your query.

Also it can be done in many ways. Suppose this is your data set.

[
  {"Id_Cust": "4145","firstName": "Albade","language": ["English,Nepali"],"degree": []},
  {"Id_Cust": "5296","firstName": "Rafael","language": [],"degree": ["Bachelor,Masters"]},
  {"Id_Cust": "6192","firstName": "Abdul","language": [],"degree": []}
]

Now, you can do:

db.collection.find({
  $or: [
    {language: {$exists: true,$not: {$size: 0}}},
    {degree: {$exists: true,$not: {$size: 0}}}
  ]
})

If your fields in array are optional fields use $exists otherwise you can exclude it.

Alternative I

db.collection.find({
  $or: [
    {language: {$ne: []}},
    {degree: {$ne: []}}
  ]
})

If your fields in array are optional fields use $exists just like in the above query.

Alternative II

db.collection.find({
  $or: [
    {language: {$gt: []}},
    { degree: {$gt: []}}
  ]
})

If your fields in array are optional fields use $exists just like in the very first query.

All methods gives same output:

[
  {
    "Id_Cust": "4145",
    "_id": ObjectId("5a934e000102030405000000"),
    "degree": [],
    "firstName": "Albade",
    "language": [
      "English,Nepali"
    ]
  },
  {
    "Id_Cust": "5296",
    "_id": ObjectId("5a934e000102030405000001"),
    "degree": [
      "Bachelor,Masters"
    ],
    "firstName": "Rafael",
    "language": []
  }
]

So, you can do it in any way.

Collectives™ on Stack Overflow

MongoDB get documents with at least one not empty array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related