Sort

Overview

The SORT is a child of Datasources that returns a sorted list based on a set field.

Restrictions:

SORT needs all fields to be the specified type expected.

Parent:

Datasources

Children:

None

Widget Attributes

Name	Type	Default	Description	Req
field	string	""	the field name to sort against	✔
type	string	"string"	The type of the field value to sort on. String, numeric, date, time, datetime
ascending	string	true	To return an ascending or descending sorted list
casesensitive	bool	false	If the string match is case sensitive when comparing.
enabled	bool	"true"	boolean expression to (en/dis)able the datasource

Examples

(fig. a)

DISTINCT on a DATA datasource

<FML>  
	<!-- We used a DATA datasource but any datasource can be used -->
	<DATA id="distinctDepartures2">
				<SORT field="departureCount" type="numeric"/>
	</DATA>
</FML>

Other Widgets You May Find Useful

• Datasources
• CALC
• PIVOT
• SORT