Lasso Soft Inc. > Home

-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>
Required Parameters
SortOrder Ascending, Descending, Custom
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 8.5, Lasso 8.0, 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 2014 | Web Development by Treefrog Inc | PrivacyLegal terms and Shipping | Contact LassoSoft