Text Sort

Description

This will sort the results by the specified text key value.

By default, empty values will be listed first, then the rest using ascending order.


Parameters

NameRequiredAvailable InDefault ValueDescription

[default] /key

 (tick)


The key chain value to sort by.

order

 (error)

ascending

May be ascending or descending.

mode

 (error)

natural

The mode of text sort to use. May be one of:

  • natural - (default) Sorts in natural language order. It will order by symbols, then digits, then letters.
  • locale - Sorts in locale-sensitive alphanumeric order. e.g.: "5", "10" and "1" will be sorted as "1", "10" and "5", because the first character of "10" is "1", which comes before "5". Punctuation order may vary depending on your locale. (Formerly called "exact")
  • bitwise - Sorts in the order of the bit value of each character. This will mean that all upper-case characters are considered to be before any lower-case characters, as well as putting most international characters at the end of the sort order.

locale

 (error)

@user

(Since 2.0.0) The locale to use when sorting text in either "natural" or "locale" mode. May be one of the following:

  • @user - (default) The current user's selected locale. Uses @global if no specific locale is selected by the user.
  • @global - The global default locale for Confluence.
  • @server - The server's default locale (may be different to @global)
  • xx_yy - A standard local value, such as "en_AU" or "de".


Editor View

Tutorial Examples