Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Import Macro Repair

...

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.

Note

Previews will not show sorted data

For performance reasons, sorting macros are not executed in Preview mode. This means the macro content could be different when the page is published.

Parameters

Name

Required

Migratable to Cloud?

Default Value

Description

[default] /key

  • Status
    title(/)

  • Status
    titleNO

The key chain value to sort by.

order

  • Status
    title(X)

  • Status
    titleNO

ascending

May be ascending or descending.

mode

  • Status
    title(X)

  • Status
    titleNO

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

  • Status
    title(X)

  • Status
    titleNO

@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

...

Macro Edit View

  • Not applicable.

Notes

  • Not applicable.

Tutorial Examples

Filter by label (Content by label)
showLabelsfalse
showSpacefalse
excerptTypesimple
cqllabel = "text-sort"

...