Mongo function to find if superstring exists in array. Nodejs,

Question

A document in my mongo 'companies' collection looks like this:

{
    "companyName": "",
    "companyIcon": "",
    "domains": [
        "companyDomainA.com",
        "companyDomainB.dev"
    ],
    "allowSubDomains": true
}

In my application the user enters his/her email address. Using the Nodejs native mongo driver (https://mongodb.github.io/node-mongodb-native), I want to query (find) which company the user belongs to.

The problem is when the user enters the email as [email protected]. I want to be able to query and find the company document of the user based on his email (subdomained 0 or more levels), ie. if the superstring of a string exists in an array in mongo. (Caveat, I cannot store all the subdomains of the company as they are dynamic and can change at will)

Is there a regular expression way/db schema change way, to achieve this?

Thanks in advance!!

Shihab · Accepted Answer · 2020-01-16 09:36:02Z

0

I would do it like this. First find the root domain from the email address. To do that I would split the email and fetch the domain first.

const email = "[email protected]";
const domain = email.split('@')[1]; // dept.companyDomainA.com

Now fetch the host (companyDomainA.com) from it. Follow this link.

So, I have found the root domain which is companyDomainA.com. Now run the find query.

db.collection('documents').find({"domains": "companyDomainA.com"});

I didn't test this code.

edited Jan 16, 2020 at 9:36

answered Dec 19, 2019 at 13:42

Shihab

2,6793 gold badges23 silver badges30 bronze badges

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

Collectives™ on Stack Overflow

Mongo function to find if superstring exists in array. Nodejs,

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related