---
title: "SetSortOrder"
slug: "setsortorder"
updated: 2023-09-29T08:58:09Z
published: 2023-09-29T08:58:09Z
canonical: "docs.datajet.app/setsortorder"
---

> ## 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.

# SetSortOrder

**Prototype**

Specifies the sort order of a field

| Key | Value(s) | Description |
| --- | --- | --- |
| method | "SetSortOrder" | Specifies the default sort order to be used on a field |
| field | "Table.Field" | Fully qualified field name - case sensitive |
| order[] | [ "label1", "label2", "label3 "label4", ] | List of labels, in sorted order |
| project | "projectname" |  |

Use this method to set a custom sort order for a field. The "order" element determines the default order in which field values will be displayed in profiles.

```json
{
  "method": "SetSortOrder",
  "field": "Sales.Profit_banded",
  "order": [
    "-6600 < -4725",
    "-4725 < -2850",
    "-2850 < -975",
    "-975 < 900",
    "900 < 2775",
    "2775 < 4650",
    "4650 < 6525",
    "6525 < 8401"
  ],
  "project": "Demonstration"
}
```