Cmdlets for Sage 300

Build 24.0.9060

OrderBy Parameter (Select-Sage300 Cmdlet)

The order in which columns will be returned.

Syntax

Select-Sage300 -OrderBy string

Remarks

The order in which columns will be returned. The value of this parameter has the same syntax as the ORDER BY clause of an SQL statement. You can specify multiple columns and the order to sort each by in a comma-separated list.

Select-Sage300 -Connection $connection -Table "OEInvoices" -Columns "ApprovedLimit ASC" -Where "Allowpartialshipments = 'Yes'"

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060