apps
2023.10
true
- Getting Started
- Before You Begin
- How To
- Build Your First App
- Build a Mobile-friendly App
- Embed Apps
- Embed Maps
- General User Experience Guidelines
- Hide Containers Using a Button
- Include Excel Charts in Apps
- Include MailTo Links
- Include Star Ratings
- Use Count With Choice Set Values
- Use Document Viewer
- Use Master Detail View
- Use Selected Values From a Table
- Use the Send Interim Result Activity
- Set External Context
- Work With Data Source and Value Bind
- Notifications
- Designing your App
- Events and Rules
- Rule: If-Then-Else
- Rule: Open a Page
- Rule: Open URL
- Rule: Close Pop-Over/Bottom Sheet
- Rule: Show Message
- Rule: Show/Hide Spinner
- Rule: Set Values
- Rule: Start Process
- Rule: Upload File to Storage Bucket
- Rule: Get File From Storage Bucket
- Rule: Reset Values
- Rule: Create/Update Entity Record
- Rule: Delete Entity Record
- Rule: Add to Queue
- Function: And, Or, Not
- Function: Concat
- Function: Contains
- Function: Count
- Function: EndsWith
- Function: If
- Function: IsBlank
- Function: Guid
- Function: Length
- Function: List
- Function: StartsWith
- Function: Sum
- Function: Sort
- Function: Now
- Function: Today
- Function: Time
- Function: Year
- Function: Month
- Function: Day
- Function: Hour
- Function: Minute
- Function: New
- Function: Lookup
- Function: Filter
- Leveraging RPA in your App
- Leveraging Entities in Your App
- Leveraging Queues in Your App
- Application Lifecycle Management (ALM)
- Basic Troubleshooting Guide
Function: Sort
LEGACY
Legacy Apps User Guide for Automation Suite
Last updated Jan 18, 2024
Function: Sort
Tip: To better understand how the Sort function works, check out the Using Apps with Data Service pages in the How To section.
Use this function to sort the information from a source based on its fields.
Attention:
This function performs a case insensitive check.
Syntax |
Description |
Example |
---|---|---|
Sort(Source, [Field, SortOrder], ...) |
Sorts the rows of a given array or range by the values in one or more columns. |
|
Argument |
Type |
Description |
---|---|---|
|
Required |
The table, array, or Entity to search (for example, a control's data property or the result of a process). |
|
Required |
The field by which to sort. It is mandatory if the source list contains complex objects. For common types (number, string, date etc), the field should not be specified. Multiple fields can be specified. |
|
Required |
Choose between
Ascending/ASC or Descending/DESC .
By default, the value is
ASC .
|
Sort(Customer, Name)
: Sort customers from a table by name (ascending order by default since no other value is given).Sort(Customer, City, Age)
: Sort customers from a table by city and age (ascending order by default since no other value is given).Sort(Customer, City, ”DESC”, Age)
: Sort customers from a table by city in a descending order, and by age in an ascending order.Sort(Customer, City, ”ASC”, Age, “DESC”)
: Sort customers from a table by city in a ascending order, and by age in an descending order.