Using SQL within attributes

Question

I'm trying to do some calculations with a field and select the value. In my attributes I have:

attributes: ['username', 'last_activity', '(last_activity - 1000) as test']

That doesn't work, since it encloses the SQL in quotes.

How can I do something like this with Sequelize?

Jan Aagaard Meier · Accepted Answer · 2014-07-04 06:54:37Z

2

With v2.0.0dev12 you can do:

Model.find({
  attributes: [
    'username', 
    'last_activity',
    // (last_activity - 1000) as test
    Sequelize.literal('(last_activity - 1000) as test')
    // (last_activity - 1000) as `test` - the as part is quoted
    [Sequelize.literal('(last_activity - 1000)'), 'test']
  ]
});

answered Jul 4, 2014 at 6:54

Jan Aagaard Meier

28.9k8 gold badges99 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gavin Over a year ago

Thanks! I'll upgrade to v2.

Collectives™ on Stack Overflow

Using SQL within attributes

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related