Job Runner

Sort Records

Overview

Sort records by the specified field.

Usage

You need to retreive the records before doing this Do. You can se Dos such as Retrieve All records or Retrieve Records by Providing Key.

Parameter

Specify Record, Key Feild 1, Key Feild 2, and Key Feild 3.

Record

Select the Action you used to retrieve the target records.

You cannot select the Action you are currently using.

Key Field 1

Key Field 2

Key Field 3

Select the fields by which to sort.

Number 1 has the highest priority, followed by 2, 3. The same values in 1 are ordered in 2; if 1 and 2 are the same, they are ordered in 3.

This parameter is optional.

Note that this parameter does not accept the following field types:

  • Checkbox
  • Multi-choice
  • Attachment
  • User selection
  • Department selection
  • Group selection
  • Table
  • Related records
  • Field group

Asc or Desc 1

Asc or Desc 2

Asc or Desc 3

Specify whether to order ascending or descending.

If Key Fields 2 and 3 are omitted, the Asc or Desc 2 and 3 settings are ignored.

Occurrence of record Retrieval Criteria

Criteria Occurrence
When Record Is Ready
When All Records Are Ready

If there is no record, neither occurs.

Restrictions

  • You can specify up to three fields. Sorting by more than four fields is not supported.