Lotus Domino Designer 8 Help

FORMULA LANGUAGE

Examples: @Sort
These examples are translation formulas. Assume that the initial value of the field is a list containing: New Boston, Albany, new york, San Francisco.

1. This formula returns: Albany, New Boston, new york, San Francisco.

@Sort(@ThisValue)

2. Same as above.

@Sort(@ThisValue; [ASCENDING])

3. This formula returns: San Francisco, New Boston, new york, and Albany.

@Sort(@ThisValue; [DESCENDING])

4. This formula returns: Albany, New Boston, New York, San Francisco.

@Sort(@ProperCase(@ThisValue); [ASCENDING])

These examples are used as the default values for form fields.

5. This formula returns 1009;85;79 if the Price column (the 5th column in the Gear view) contains the prices 79, 85, and 1009 for three entries in the Ski Pants category:

@Sort(@DbLookup("";"Server/Name/Notes":"Ski\\Clothing.nsf";"Gear";"Ski Pants";5);[DESCENDING])

6. This formula returns the contents of the movies field in order from the shortest title to the longest; it returns ET;casablanca;The Great Escape when the movies field contains "casablanca":"The Great Escape":"ET":

@Sort(movies;[CASESENSITIVE]:[CUSTOMSORT];@If(@Length($A) < @Length($B);-1;@Length($A) > @Length($B);1;0))

Note that the custom sort keyword overrides the case-sensitivity keyword.

7. This formula returns the following passwords in order from the strongest to the weakest: HE5ll+o;Hel$lo;hello, when the pswd1 field contains "Hello", pswd2 field contains "HE5ll+o", and the pswd3 field contains "Hel$lo."

@Sort(pswd1:pswd2:pswd3;[CUSTOMSORT];@If(@PasswordQuality($A) < @PasswordQuality($B);1;@PasswordQuality($A) > @PasswordQuality($B);-1;0))

8. This formula returns: cat, Cat, CAT, dog when the animals field contains "CAT, Cat, dog, cat".

@Sort(animals;[CASESENSITIVE])

See Also

@Sort

Glossary

Feedback on Help or Product Usability?

Help on Help

All Help Contents

Glossary