How to use array_agg() in sequelize?

Question

I want to use array_agg() function with sequelize. How can I do that ? I have been used below code, but it doesn't work.

let statusTabs = await Parameters.findAll({
    where: {
        param_key: 't_status',
        param_name: ['Washing', 'Awaiting', 'Pending']
    },
    attributes: [
        sequelize.literal('array_agg(param_key)'),
        sequelize.fn('array_agg', sequelize.col('param_key'))
    ]
});

It is giving errors like below -

TypeError: Cannot read property 'fn' of undefined

TypeError: Cannot read property 'literal' of undefined

How can I get array_agg() to work ?

I got the issue. The issue was regarding sequelize instance. It was not getting the proper instance of it. — Suraj Singh
– Suraj Singh, Commented Apr 7, 2021 at 6:01

Chingiz Bakhishov · Accepted Answer · 2021-04-05 18:24:35Z

3

This worked for me

Zone.findAll({
  attributes: [[Sequelize.fn('array_agg', Sequelize.col('city')), 'zones']],
  where: { country: 'Canada' },
  group: ['country']
})

answered Apr 5, 2021 at 18:24

Chingiz Bakhishov

514 bronze badges

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

Collectives™ on Stack Overflow

How to use array_agg() in sequelize?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related