Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
794 views
in Technique[技术] by (71.8m points)

sequelize.js - Sequelize - return new field based on value of another field

I have my a Sequelize function that returns all my users in the DB based on a single condition and it works great. Now I want to add a field to the returned fields that is created and depends on a value from a field. So if reset_link is NULL, I would return status as one value, otherwise return status as a different value.

I realize I could just return the reset_link but I don't want to return that value if I don't have to.

Here is my current findAll function.

const users = await db.User.findAll({
                raw: true,
                attributes: [
                    ['id', 'userID'],
                    'first_name',
                    'last_name',
                    'email',
                    'phone',
                    'Permission.type'
                    // 'Permission.id'
                ],
                include: [
                    {
                        model: db.Permission,
                        where: { id: { [Op.gt]: 3 } },
                        attributes: []
                    }
                ],
                where: { customer_id: args.customer_id },
                order: [[{ model: db.Permission }, 'id', 'ASC']]
            });
question from:https://stackoverflow.com/questions/66052783/sequelize-return-new-field-based-on-value-of-another-field

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)
Waitting for answers

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...