-SortOrder
When specified after a -SortField or -SortColumn tag, -SortOrder specifies the order in which the field or column should be sorted. Possible values include Ascending or Descending to sort in alphabetical or numerical order and Custom to sort in a data source dependent order.
FileMaker Pro Note: Custom order can be used to sort a field in the order specified by a value list.
- Syntax
- Parameters
[Inline: -SortField='Field_Name', -SortOrder='Ascending'...]
<a href="default.lasso?-SortField=Field_Name&-SortOrder=Descending&...">Link</a>
<form action="default.lasso" method="POST">
<input type="hidden" name="-SortField" value="Field_Name">
<input type="hidden" name="-SortOrder" value="Custom">
...
</form>Examples
To sort the results of a database action:
Use the -SortField and -SortOrder command tags. The following example specifies a -Search action in [Inline] ... [/Inline] tags. The results are sorted in descending order by Last_Name.
[Inline: -Search,
-Database='Contacts',
-Table='People',
-SortField='Last_Name',
-SortOrder='Descending',
'First_Name'='John']
[Records]
<br>[Field: 'First_Name'] [Field: 'Last_Name']
[/Records]
[/Inline]Result:
<br>John Surname
<br>John Doe
| Tag Link | -SortOrder | Category | Database |
|---|---|---|---|
| Type | Command | Data Source | Any |
| Support | Preferred | Version | 2.5 |
| Output Type | None | Security | None |
| Implementation | LCAPI | Sets | Lasso 7.0, Lasso 6.0, Lasso 5.0,LDML3x,LDML25 |
Please note that periodically LassoSoft will go through the notes and may incorporate information from them into the documentation. Any submission here gives LassoSoft a non-exclusive license and will be made available in various formats to the Lasso community.
LassoSoft Inc. > Home
©LassoSoft Inc 2015 | Web Development by Treefrog Inc | Privacy | Legal terms and Shipping | Contact LassoSoft