NodeJS with MySQL - Return blank Array

I have initialized an array "userTasklist". I have pushed the object in this array in .map function. After .map, I have console this Array but array is blank.

Than I have console the object in .map function and all the value print successfully but in Array there are no value. Don't know why.

exports.allUserList = (req, res) => {
    let userID = req.params.userid;
    const ghusersQuery = "SELECT user_id, name, employee_code FROM users WHERE under_gh = ?";
    conn.query(ghusersQuery, [userID], (err, userdata) => {
        if (err) {
            res.send({ message: err })
        } else {
            if (userdata && userdata.length > 0) {
                let userTasklist = [];
                userdata.map((datauser) => {
                    var objtask = {};
                    const userDataQuery = "SELECT * FROM tasklist WHERE user_id = ?";
                    conn.query(userDataQuery, [datauser.user_id], (errnew, taskdata) => {
                        if (taskdata && taskdata.length > 0) {
                            objtask = {
                                userid: datauser.user_id,
                                tasklist: taskdata
                            }
                            userTasklist.push(objtask);
                        }
                    })
                })
                console.log(userTasklist)
                res.send({ message: "user list fetched", userdata: userdata, tasklistdata: userTasklist })
            } else {
                res.send({ message: "Data not found!" })
            }
        }
    })
}


from Recent Questions - Stack Overflow https://ift.tt/3uePCrN
https://ift.tt/eA8V8J

Comments

Popular posts from this blog

Today Walkin 14th-Sept

Spring Elasticsearch Operations

Hibernate Search - Elasticsearch with JSON manipulation