Optional
If an array: a list of the attributes that you want to select. Attributes can also be raw SQL (literal), fn, and col
literal
fn
col
To rename an attribute, you can pass an array, with two elements:
If include is used: selects all the attributes of the model, plus some additional ones. Useful for aggregations.
include
{ attributes: { include: [[literal('COUNT(id)'), 'total']] }
If exclude is used: selects all the attributes of the model, except the one specified in exclude. Useful for security purposes
exclude
{ attributes: { exclude: ['password'] } }
Generated using TypeDoc
If an array: a list of the attributes that you want to select. Attributes can also be raw SQL (
literal
),fn
, andcol
To rename an attribute, you can pass an array, with two elements:
literal
,fn
,col
),If
include
is used: selects all the attributes of the model, plus some additional ones. Useful for aggregations.Example
If
exclude
is used: selects all the attributes of the model, except the one specified in exclude. Useful for security purposesExample