CODEWITHSUNDEEP
javascriptsqlitesequelize.js
Foridur Kayes Shawon
Foridur Kayes Shawon

Reputation: 91

How to write case insensitive order query in sequelize(SQLite)?

I am trying to order by my data based on an attribute. Here I have a model name Farmer and I am ordering this model by name. The query is like this:

Farmer.findAll({order: [['name', 'ASC']]})

Which is ordering data case sensitively. But I want to order this case insensitively. How can i get it?

Upvotes: 2

Views: 2382

Answers (1)

marcobiedermann
marcobiedermann

Reputation: 4915

You could use sequelize.fn (http://docs.sequelizejs.com/class/lib/sequelize.js~Sequelize.html#static-method-fn) to transform your name to lowercase

Farmer.findAll({
  order: [
    [
      Sequelize.fn('lower', Sequelize.col('name')),
      'ASC',
    ],
  ],
});

Upvotes: 3

Related Questions