The sorting order for the result set on a database query. The result set is based on the configuration settings of the Database, Table, SQLServer, Parameters, and ParameterCondition properties. More than one property can be provided to sort the results by more than one property.

For example, if Order=Sequence is specified in the CustomSettings.ini file, then an ORDER BY sequence clause is added to the query. Specifying Order=Make, Model adds an ORDER BY Make, Model clause to the query.

 

Property configured by

 

 

Property applies to

 

BootStrap.ini

˜

 

LTI

˜

CustomSettings.ini

˜

 

 

 

MDT DB

 

 

ZTI

˜

 

Value

Description

property1, property2, …

Properties to define the sort order for the result set (where propertyn represents the properties in the sort criteria)

 

Example

[Settings]

Priority=Computers, Default

 

[Default]

OSInstall=YES

ScanStateArgs=/v:5 /o /c

LoadStateArgs=/v:5 /c /lac

 

[Computers]

SQLServer=NYC-SQL-01

SQLShare=SQL$

NetLib=DBNMPNTW

Database=MDTDB

Instance=SQLEnterprise2005

Table=MakeModelSettings

Parameters=SerialNumber, AssetTag

ParameterCondition=OR

Order=Make, Model

 

Related Topics

Property Definition