a!sortInfo() Function

Creates a value of type SortInfo for use with grids and record queries.

Syntax

a!sortInfo( field, ascending )

  • field (Any Type): The name of the field by which to sort the data. When sorting record data, reference a record field using the recordType! domain. For example, recordType!Case.fields.caseName.
  • ascending (Boolean): Determines whether the data sorts in ascending or descending order. Default is false, which means descending.

Returns

SortInfo

Notes

  • Sorting is only supported for complex data types and is not supported for a dictionary array.
  • When sorting on aggregated data, the field parameter can also accept the alias.

Examples

You can copy and paste these examples into the Expression Rule Designer to see how this works.

1
2
3
4
	=a!sortInfo(
	  field: "name",
	  ascending: true()
	)

returns

	[field=name,
	 ascending=true]

See Also

a!pagingInfo(): Use the a!sortInfo() function to create a value for the sort parameter of this function.

SortInfo: This is the data type the a!sortInfo() function returns.

Read-Only Grid: Use the a!sortInfo() function to sort the data for a grid component on an interface.

a!queryRecordtype: Use the a!sortInfo() function to sort the data queried from a record type.

Open in Github Built: Mon, Oct 18, 2021 (03:00:16 PM)

On This Page

FEEDBACK