Spring - Filter by not empty array not working in Mongo

Question

I have the following query:

@CountQuery("{$and:[" +
                "{ 'active' : true }," +
                "{ 'budget' : { $ne: { $size: 0 } } }" +
            "]}")
Integer countByBudgets();

and this document:

{
  id: ...,
  active: true,
  budget: []
}

And the query above is returning 1 when it should return 0 as the budget field has no values.

What am I doing wrong?

Thanks

Wrong · Accepted Answer · 2019-07-15 09:18:47Z

1

Okay, changing the following part worked:

"{ 'budget' : { $ne: [] } }"

answered Jul 15, 2019 at 9:18

Wrong

1,2733 gold badges16 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

Spring - Filter by not empty array not working in Mongo

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related