Is there a way to use MongoDB query objects to filter regular JavaScript arrays?

Question

In MongoDB, you can use JSON-style objects such as in the following to query a collection:

db.things.find({ x : { $ne : 3 }, y : 'foo' });

I'd like to reuse that { x : { $ne : 3 }, y : 'foo' } bit and use it to filter an array of JavaScript objects.

Is there any code/library out there that can do that, and that supports all the query options (or as much as makes sense anyway)?

sounds like a good suggestion for the MongoDB folks to add to their library. — Jason S, Jan 02 '12 at 19:03

Emil Stenström · Accepted Answer · 2021-03-06T06:10:02.623

11

Ok, so here's another try:

sift.js (npm: sift) by Craig Condon is a MongoDB-inspired array filtering library. It’s a bit like an alternative to Underscore for people who love MongoDB. Sift.js supports operators like $in and $gt, but can also filter arrays based on functions and even works with deeply-nested objects in arrays.

Craig has provided a few examples that should look familiar to Mongo users:

var sift = require('sift');

sift({ $in: ['hello','world'] }, ['hello','sifted','array!']); //
['hello']

Source (Edited): Daily JS, but seems site is down.

edited Mar 06 '21 at 06:10

answered Jan 04 '12 at 20:43

Emil Stenström

13,329
8
53
75

Oh, this looks perfect! Nice find. Thanks – emertechie Jan 05 '12 at 20:54
@Emil, thats a nice find.. +1 – RameshVel Jan 16 '12 at 11:19
Wow! The best one ever used for far. – Wen Oct 29 '20 at 23:12

score 4 · Answer 2 · answered Feb 08 '17 at 09:11

4

As far as I can see, Mingo has wider Mongo queries support than Sift.

answered Feb 08 '17 at 09:11

Karol Selak

4,248
6
35
65

score 2 · Answer 3 · answered Jan 01 '12 at 21:50

2

Underscore.js is a great library to do map/reduce kind of jobs on javascript structures. Highly recommended.

answered Jan 01 '12 at 21:50

Emil Stenström

13,329
8
53
75

Those are also natively available in `Array.prototype` on more modern browsers. I think the OP is wanting to pass an object to filter the Mongo way (I guess including atomic operations like `$in`). – pimvdb Jan 01 '12 at 22:49
Correct, I want to be able to use the same filter to filter MongoDB data _and_ regular JavaScript arrays – emertechie Jan 02 '12 at 18:50

score 1 · Answer 4 · answered Oct 12 '14 at 11:16

1

You can use https://github.com/mirek/node-json-criteria library, which evaluates critera queries in MongoDB format on JSON objects.

answered Oct 12 '14 at 11:16

Mirek Rusin

18,820
3
43
36

score -1 · Answer 5 · answered Jan 03 '12 at 10:01

I dont think you can just use the mongodb filters in normal js arrays. Because you need to understand the fact that

The filters specified in mongodb are evaluated in mongodb indexes not in the javascript result set

Means the filters evaluated(translated) to query against a index not the js. So what you are asking is a DSL on top of mongodb(or JS) which will evaluate the mongodb index filters in the JS array.

I dont think its needed since both serves the different purposes (Though its possible(difficult) to write custom DSL). Also there are major frameworks like underscore.js already provide a ways to handle these.

Is there a way to use MongoDB query objects to filter regular JavaScript arrays?

5 Answers5

Linked