"OR" query in Meteor

Question

I'm trying to find documents where the boxId field is not set or empty.

Running this does not work:

return Items.find({ createdBy: currenUser, boxId: { $or: [{ $exists: false }, { $size: 0 }] } })

Here's the error I get on the console:

Exception in template helper: Error: Unrecognized operator: $or

Michel Floyd · Accepted Answer · 2016-03-23T18:37:28.127

2

The ordering of mongodb key names and operators can often be confusing. Put the $or before the field conditions:

return Items.find({ createdBy: currentUser,
  $or: [
    { boxId: { $exists: false }},
    { boxId: "" }}
  ]
});

edited Mar 23 '16 at 18:37

answered Mar 23 '16 at 18:25

Michel Floyd

I'm not getting the error anymore, but it is not returning documents where the boxId field is "" (empty quotes). Is $size the right operator for this? – Fábio Queluci Mar 23 '16 at 18:34
See http://stackoverflow.com/a/9694397/2805154 for a related question and approach – Michel Floyd Mar 23 '16 at 18:37
My bad, I forgot to replace $size with your second condition. It works now. Thanks! – Fábio Queluci Mar 23 '16 at 19:00

1 Answers1