find value in nested array with mongoose

Question

I have the following schema :

const ClientManagerSchema = new Schema({
    name : { type : String,  required : true},
    project : [ProjectSchema]
});

The project one looks like this :

const ProjectSchema = new Schema({
    companyName : {type: String , required : true}, 
    projectName : String, 
    projectManager : String, 
    projectManagerUrl : String, 
    employees : [], 
    contactPerson : [], 
    employeeInfo : [], 
    projectHours : [], 
    trelloUrl : String, 
    dataStudioUrl : String,
    projectUrl : String,
    AnalyticsEmail : String,
    companyId : String,
    projectId : String,
    total : Number,
    totalIn : Number,
    totalSt : Number,
    totalSale : Number,
    earliestDate : String, 
    firstEvaluation : String,
    secondEvaluation : String, 
    firstEvaluationIndex : Number,
    secondEvaluationIndex : Number,
    revenueGroups : [RevenueGroupSchema],
    revenueGroupsIn : [RevenueGroupSchema],
    revenueGroupsSt : [RevenueGroupSchema],
    sales : [RevenueGroupSchema],
    saleData : [],
});

I want to select all documents from my database that have the company name "test bv". But since the projects value is nested im not sure how to do it. I could also lift the value to a level where i can easily access it but thats not optimal.

I tried some things which didn't work :

ClientManager.find({'companyName': 'test bv'}).then((res) => console.log(res)).catch(err => console.log(err))

This gave me an empty array..

Sven.hig · Accepted Answer · 2020-07-16 14:42:47Z

2

change this find({'companyName': 'test bv'})to this find({'project.companyName': 'test bv'})

answered Jul 16, 2020 at 14:42

Sven.hig

4,5292 gold badges10 silver badges18 bronze badges

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

Comments

Denerator · Accepted Answer · 2020-07-16 14:38:29Z

1

ClientManager.find({'project.companyName': 'test bv'}).then((res) => console.log(res)).catch(err => console.log(err))

answered Jul 16, 2020 at 14:38

Denerator

4515 silver badges13 bronze badges

Collectives™ on Stack Overflow

find value in nested array with mongoose

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related