SQLite - Order by / Sort

Questions and Answers Database-SQL
1

Hello,

How can I sort data with strapi.query().findOne({Id}) on Sqlite?
I want to sort it ascending by the created_at field.

Thanks

System Information
  • Strapi Version: 3.2.5
  • Operating System: ubuntu 18.04 lts
  • Database: sqlite
  • Node Version: v12.18.4
  • Yarn Version: 1.22.5
2

strapi.query(...).findOne({_sort: 'created_at:asc'});

2 Likes