Sequelize return array with Strings instead of Objects

Question

Sometimes i only want to select a single value from multiple rows.

Lets imagine i have an account model which looks like this:

Account

Id
Name
Age

And i would only like to select the names.

You would write something like this:

AccountModel.findAll({
        where: {
            Age: {
                $gt : 18
            }
        },
        attributes: ['Name'],
        raw : true
    });

But this would return in an array with objects.

[{Name : "Sample 1"}, {"Name" : "Sample 2"}]

I would like to get an array with only names like this:

["Sample 1", "Sample 2"]

Is it possible to achieve this with Sequelize? I've searched trough the documentation but couldn't find it.

cfogelberg · Accepted Answer · 2015-11-07 07:28:08Z

Using Sequelize 3.13.0 it looks like it isn't possible to have find return a flat array of values rather than an array of objects.

One solution to your problem is to map the results using underscore or lodash:

AccountModel.findAll({
    where: {
        Age: {
            $gt : 18
        }
    },
    attributes: ['Name'],
    raw : true
})
.then(function(accounts) {
  return _.map(accounts, function(account) { return account.Name; })
})

I've uploaded a script that demonstrates this here.

As a quick note, setting raw: true makes the Sequelize find methods return plain old JavaScript objects (i.e. no Instance methods or metadata). This may be important for performance, but does not change the returned values after conversion to JSON. That is because Instance::toJSON always returns a plain JavaScript object (no Instance methods or metadata).

ThisGuyCantEven · Accepted Answer · 2022-11-08 03:15:21Z

Here is a nice ES6 version of cfogelberg's answer using lambda expressions (Array.prototype.map() only works in IE9+ and lambda (arrow) functions have no IE support):

AccountModel.findAll({
    where: {
        Age: {
            $gt : 18
        }
    },
    attributes: ['Name'],
    raw : true
})
.then(accounts => accounts.map(account => account.Name));

Snippet (does not work in ie):

Here is a baby snippet I used for proof of concept. If it doesn't work, you are using one of the unsupported browsers mentioned above (and you shouldn't be making db calls directly from the browser anyway):

const objArray=[{key:1},{key:2},{key:3}];
console.log("Not IE friendly:");
console.log(objArray.map(obj => obj.key));
console.log("IE friendly (might even be ES3 if you change \"let\" to \"var\"):");
let names = [];
for(let i=0 ; i<objArray.length ; i++){
    names[i] = objArray[i].key
}
console.log(names)

Fábio BC Souza · Accepted Answer · 2021-02-03 17:45:55Z

8

2020 Solution

Hi folks, you can easily do your pure "pluck" method:

const someVariable = [
  ... ( await AccountModel.findAll({
    where: {
        Age: {
            $gt : 18
        }
    },
    attributes: ['Name'],
    raw : true
  })),
].map(account => account.Name);

edited Feb 3, 2021 at 17:45

answered Dec 15, 2020 at 1:06

Fábio BC Souza

1,22022 silver badges25 bronze badges

1 Comment

ThisGuyCantEven Over a year ago

This is a nice ES7 solution

Li Zheng · Accepted Answer · 2016-05-11 06:49:37Z

3

arr-pluck works well:

var pluck = require('arr-pluck');

AccountModel.findAll({
    where: {
        Age: {
            $gt : 18
        }
    },
    attributes: ['Name'],
    raw : true
})
.then(function(accounts) {
  return pluck(accounts, 'Name');
})

answered May 11, 2016 at 6:49

Li Zheng

7411 gold badge8 silver badges13 bronze badges

2 Comments

ThisGuyCantEven Over a year ago

Idk why anyone downvoted this, other answers also use 3rd party libs (like lodash). Technically mine is the only pure nodejs/sequelize solution, but there is nothing wrong with this one...

ThisGuyCantEven Over a year ago

Update: Fabio's answer is also pure js

Collectives™ on Stack Overflow

Sequelize return array with Strings instead of Objects

4 Answers 4

Comments

Snippet (does not work in ie):

Comments

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Snippet (does not work in ie):

Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related