Select specific fields from database
Yes, it's possible, you just need to add select
to your search criteria, for example (assuming you are searching for a records with id 1):
userModel.find({ select: ['phone'], id: 1 })
or alternatively:
userModel.find({ select: ['phone'], where: { id: 1 } })
or if you want all records, you don't need to supply criteria:
userModel.find({ select: ['phone'] })
This doesn't seem to be documented anywhere but it should. In version 0.11 it will also possible to define select by doing model.pick('name', 'age')
: https://github.com/balderdashy/waterline/pull/952
Source and more detail -https://stackoverflow.com/a/24170388/1392194
Yes, it's possible but not with select
as it's still in development. But there is a way to achieve it using fields
.
Model.find({ id: id }, {
fields: {
name: 1,
phoneNumber: 1
}
}).limit(1).exec(function(...) {};
This won't work with findOne
.