How to get custom fields in association table Sequelize js

Question

"I want to get some attributes of an include table instead of using *, my code right now is this.

module.exports = function(app){
    app.get('/post', function(req, res){
        model.Post.findAll(
            { attributes: ["body", "id"],
            {include: [model.User]).success(function(rows){
                    res.json(rows);
            }

        );


    });

This works fine , but the query gets some data that i really don't need( password, birth, email) How can i get only , for example the username and avatar of the inlclude table User?

EmptyArsenal · Answer 1 · 2014-02-19T19:32:40.257

1

You should be able to specify what you want back via the attributes property. I'm not sure what your schema looks like, so I may need to look a little different, but here's my best guess:

// If password, birth, and email are nested in the body:
{ attributes: ["body.username", "body.avatar", "id"],
...

That should work. If not, please post your schema.

edited Feb 19 '14 at 19:32

answered Dec 18 '13 at 00:23

EmptyArsenal

7,314
4
33
56

did you mean `{ attributes: ["body", ["username", "avatar"], "id"], ...`? – borisdiakur Feb 19 '14 at 14:02
I'm not sure that my syntax was right, but how you have it, it will return `body`, `id`, and rename the `username` attribute to `avatar`. – EmptyArsenal Feb 19 '14 at 16:40
The only thing I know is that the code in your answer has a syntax error at the second colon. – borisdiakur Feb 19 '14 at 19:26
1

Sorry, but your answer is still not correct. Right answer here: http://stackoverflow.com/a/21907320/601466 – borisdiakur Feb 21 '14 at 08:32

How to get custom fields in association table Sequelize js

1 Answers1