Panel

name	blue

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.

...

Name	Description	Value
fieldDefines how the data will be ordered	A table field.	Any field name
sortorder	Define Defines the sorting order of the data.	ASC or DESC

Example

Expand

title	Order By

Code Block

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