Order By

An order by clause in SQL specifies that a SQL select statement returns a result set with the rows being sorted by the values of one or more columns.

Attributes

Name	Description	Value
field	A table field.	Any field name
sortorder	Defines the sorting order of the data.	ASC or DESC

Order By

Order By

...
 
	<orderby>
		<fielditem>
			<field>OUGROUPS.OUGNAME</field>        
			<sortorder>ASC</sortorder>   
		</fielditem>
	</orderby>
 
...