> For the complete documentation index, see [llms.txt](https://dexiejs.typogram.co/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://dexiejs.typogram.co/table/table.orderby.md).

# Table.orderBy()

Return a collection of all items in table where the property is set to an [indexable type](https://dexie.org/docs/Indexable-Type) ordered by given indexed property. Objects where the property is not set to an [indexable type](https://dexie.org/docs/Indexable-Type) will not be included in the result.

#### Syntax

```javascript
table.orderBy(index)
```

#### Parameters

#### Return Value

Collection

#### Remarks

Returns an unfiltered collection sorted by the index or primary key given by `index`. Note that `index` can only be an indexed property or the primary key. If you want to sort by an un-indexed property, then use Collection.sortBy() instead.

#### OrderBy on Collections

In current version of Dexie (v3.0), it is not possible to do:

```javascript
db.friends
  .where('age').above(25)
  .orderBy('name') // Not possible in Dexie 1.x, 2.x or 3.x.
```

... and there is a simple reason for that: No database can do this query easily as it can only operate on one B-tree at a time. However, most databases yet supports, but involving set matching of primary keys and a full index scans on the ordered query.

Even though current version of Dexie (v3.0) does not have orderBy() on Collections, the feature may be introduced in a future version, and can already be accomplished without using sortBy() - see [this sample](https://dexie.org/docs/Collection/Collection.offset\(\)#paged-or-queries).

#### Sample

See the sample in Table.offset().

#### See Also

Collection.sortBy()

[A better paging approach](https://dexie.org/docs/Collection/Collection.offset\(\)#a-better-paging-approach)