In LokiJS I try a very simple query (which I assume is AND):

var dbRes = recsCol.find({'format':format, 'cardId':-1});

after inserting some data with

recsCol.insert({format:format, cardId:id, recCardId:key, amount:item[key]});

that doesn't contain a cardId of -1.

The query still yields results. Is this expected behaviour? If so, how can I make the fields match exactly so that I won't get a result in this case?

In LokiJS I try a very simple query (which I assume is AND):

var dbRes = recsCol.find({'format':format, 'cardId':-1});

after inserting some data with

recsCol.insert({format:format, cardId:id, recCardId:key, amount:item[key]});

that doesn't contain a cardId of -1.

The query still yields results. Is this expected behaviour? If so, how can I make the fields match exactly so that I won't get a result in this case?

• javascript
• in-memory-database
• lokijs
• nosql

Share Improve this question Follow edited Sep 22, 2017 at 18:01 CommunityBot 111 silver badge asked Aug 15, 2015 at 11:51 WonkoWonko 17611 silver badge99 bronze badges

Add a ment  | 

2 Answers 2

Sorted by: Reset to default 6

You can do an AND in LokiJS, no problem:

var dbRes = recsCol.find({'$and': [{'format':format}, {'cardId':-1}]});

I remend using find for one-off queries. If the query occurs multiple times on resultsets that may change then definitely use a view.

By default, all fields in a query object are treated as an OR. To make it an AND you will need to change your query syntax to the following:

recsCol.find({
    $and: [
        {'format':format},
        {'cardId':-1}
    ]
});