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