mongo-query-parse-filter

Mongo Query Parse Filter

Lightweight package that allows you to easily convert complex, human-readable query filters into MongoDB-compatible query syntax, supporting logical operations like AND, OR, NOT, IN, NIN and various comparison operators

Table of Contents

• Installation
• Usage
• Example

Installation

To install the package, use npm:

npm i mongo-query-parse-filter

Usage

const { MongoQuery } = require('mongo-query-parse-filter');

const mongoQuery = new MongoQuery();

const query = mongoQuery.buildQuery('(email eq "[e-mail]")')

console.log(query)

Result

{
    "email": { "$eq": "[e-mail]" }
}

Example

eq,neq,gt,gte,lt,lte,regex: (email regex "(?i)@example.com$")

{
    "email": { "$regex": "(?i)@example.com$" }
}

OR/AND: (email eq "[e-mail]") or (username eq "alice")

{
    "$or": [
        {
            "email": { "$eq": "[e-mail]" }
        },
        {
            "username": { "$eq": "alice" }
        }
    ]
}

NOT: (not ((department eq "Marketing") or (department eq "Sales")))

to find all employees who are not either in the Marketing or Sales departments

{
    "$not": {
        "$or": [
            {
                "department": { "$eq": "Marketing" }
            },
            {
                "department": { "$eq": "Sales" }
            }
        ]
    }
}

IN/NIN: (email in "'[e-mail]','[e-mail]'")

{
    "email": { "$in": [ "[e-mail]", "[e-mail]"] }
}