Skip to main content

Order By

Order By is used to sort the data in ascending or descending order, based on any column.

Sql

Select * from Table_Name Order by column_name sort_type;

JsStore

var results = await connection.select({
from: "Table_Name",
order: {
by: column_name,
type: sort_type //supprted sort type is - asc,desc
}
});
//results will be array of objects.
console.log(results);

Option

Order has following options -

  • by: string; // sorting column name

  • type: string; // sorting type - asc/desc, default is asc

  • idbSorting: boolean // whether to do sorting by indexeddb or by jsstore, default - true

Example

By multiple column

For ordering by multiple column - you need to provide all order object value in an array

var results = await connection.select({
from: "Table_Name",
order: [{
by: column_name1,
type: sort_type //supprted sort type is - asc,desc
},
{
by: column_name2,
type: sort_type //supprted sort type is - asc,desc
}]
});
//results will be array of objects.
console.log(results);

Example

In join

Unlike query without join, order here is little different. You need to provide query along with table name in the form of [tablename].[columnName]

select({
from: "Student",
join: {
with: "StudentDetail",
on: "Student.Name=StudentDetail.Name"
},
order: { by: 'Student.Order', type: 'asc' }
})

Example