How does mongoose query based on join table fields or virtual fields?

router.get("/VaguePartner", function (req, res, next) {
    const keyWords = req.query.keyWords
    t_Superior.find().populate("consumer firstsuperior").where("consumer").or([
        { "nickname": { "$regex": keyWords, $options: "$i" } },
        { "phonenumger": { "$regex": keyWords, $options: "$i" } }
    ]).then(docs => {
        res.send(docs)
    })
})

I use mongoose virtual fields to join table queries. The associated consumer,nickname and phonenumger are both fields in the consumer table. T_Superior does not exist this field. How can I query it?

Node.js mongodb mongoose

Mar.06,2021

.populate can't do this, you need to use .popularity .

Previous: BUG used with jQuery fadeOut (). Queue ()

Next: How can I modify the variables passed outside the function?

[mongoose] how does populate relate to a non-_ id field?
new Schema({ pid: {type: String, ref: product }, sid: {type: String, ref: sale }, })); suppose there are product and sale two collections pid and sid both specify user_id of the product and sale collections instead of _ id ...

Node.js mongodb mongoose

Mar.20,2021
How does mongoose find a value in an array?
for example const ProjectSchema = new mongoose.Schema ({) name : { type:String }, time : { type:Date, default:Date.now }, url : { type: String}, user : { type: Object}, proId : {type: String}, spaceId : {type: String}, description: {type: String...

Node.js mongodb mongoose

Mar.28,2021
How do I delete data at a specific location in an array in the Models of Mongoose?
problem description how do I delete data at a specific location in an array in mongodb? the entity of an aircraft like this: number:B-xxxx, components:[fuselage,wings,engines,landinggears] I now want to delete the third data in components, but I c...

Node.js mongodb mongoose

Apr.02,2021
Mongoose populate doesn't seem to work. I've been confused for two days.
problem description mongoose populate doesn t seem to work. Confusingly, I use it in another part of the project, and it s normal . the environmental background of the problems and what methods you have tried mongodb: 4.0.1 mongoose: 5.2.9 rel...

Node.js mongodb mongoose

May.15,2021
Express is using Model to operate mongodb Times wrong, I don't know why, ask for advice
when you create a user, you will first query the data in the table. There is a mistake here in the query. I don t understand the reason. Please give me some advice: user model: models User.js const mongoose = require( mongoose ); const Schema = ...

Node.js mongodb mongoose

Feb.24,2022

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-42a651d-5f9c.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-42a651d-5f9c.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?