---
title: "SortTable"
slug: "sorttable"
updated: 2023-11-13T13:38:53Z
published: 2023-11-13T13:38:53Z
canonical: "docs.datajet.app/sorttable"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datajet.app/llms.txt
> Use this file to discover all available pages before exploring further.

# SortTable

Sorts a small table, based on a sort key.

Limitations

- This method is only suitable for tables where the sort key and the biggest field can be loaded into memory
- Generally this works out at around 500m records on a server with 64BG RAM

| Key | Value(s) | Description |
| --- | --- | --- |
| method | "SortTable" | Sorts a small table, based on a sort key. |
| table | "TableName" | Name of table to sort |
| sortKey | "ShortFieldName" | Short name of key to sort by. Sort will be ascending. |
| project | "CurrentProjectName" | Name of current project |

{Explanation}

```json
{
  "method": "SortTable",
  "table": "constructor%DSTAMP%",
  "sortKey": "sortkey",
  "project": "SmallTrans"
}
```