OrderBy function

This article describes the formula syntax and usage of the OrderBy function in JungleDocs.


Description

Orders recordSet items by fieldName values in ascending or descending direction.

Syntax

OrderBy(recordSet; fieldName)

OrderBy(recordSet; fieldName; ascending)

OrderBy(recordSet; fieldName1; ascending1; fieldName2; ascending2)

OrderBy(recordSet; fieldName1; ascending1; fieldName2; ascending2; fieldname3; ascending3)

The OrderBy function syntax has the following arguments:

  • recordSet   Required. Any command that returns a list of items (e.g., GetView()).
  • fieldName   Required. The name of the field that you want to order recordSet by.
  • ascending    Optional. Values of true and false are supported.

Remarks

  • Supports up to 3 fields.
  • Orders in ascending direction if ascending is true or in descending direction if ascending is false.

Examples

OrderBy(ReportItems; "Modified"; false)

Orders report items by Modified date – newest on top. 

OrderBy(GetView("Tasks"; "AllItems"); "Order")

Orders tasks by SharePoint system column Order. 

OrderBy(GetView("Tasks"; "AllItems"); "Priority"; true; "Order")

Orders tasks by priority then by SharePoint system column Order. 

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us