| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
List.SortWithEvaluate
Sorts a list with using an expression to evaluate.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| List | 10.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "List.SortWithEvaluate"; List; Expression { ; NoReturnEnding } ) More
Parameters
| Parameter | Description | Example | Flags |
|---|---|---|---|
| List | The list to sort. | "Hello" ¶ "World" | |
| Expression | The expression to evaluate. Can include "leftValue" and "rightValue" as variables. |
"leftValue > rightValue" | |
| NoReturnEnding | Pass 1 to have no extra newline character on the end of the returned list. Default is 0 to include one to easily concat lists. | 1 | Optional |
Result
Returns OK or error.
Description
Sorts a list with using an expression to evaluate.The expression is run every time two values are compared, so keep it quick. It should return 1 if leftValue is smaller than rightValue.
Our normal List.Sort is faster due to not having the overhead of evaluating expressions.
Examples
Sort numbers numeric with GetAsNumber() function:
MBS("List.SortWithEvaluate"; "1¶22¶3"; "GetAsNumber(leftValue) < GetAsNumber(rightValue)")
Example result:
1
3
22
Sort dates with using GetAsDate:
MBS("List.SortWithEvaluate"; "1/1/2000¶2/22/2020¶3/4/1998"; "GetAsDate(leftValue) < GetAsDate(rightValue)")
See also
Release notes
- Version 10.2
- Added List.SortWithEvaluate and QuickList.SortWithEvaluate functions to sort lists with custom expression.
Blog Entries
- News about the MBS FileMaker Plugin 10.2
- Neues MBS FileMaker Plugin 10.2
- MBS FileMaker Plugin 10.2 - More than 6200 Functions In One Plugin
- MBS FileMaker Plugin, version 10.2pr3
- Sort with evaluate in FileMaker
This function checks for a license.
Created 9th April 2020, last changed 13th May 2020
