MES Stateless API

GetByFilter(Boolean,Boolean,Boolean) Method

Save PDF

GetByFilter(Boolean,Boolean,Boolean) Method

Save PDF

Last UpdatedNov 06, 2025
2 minute read

The GetByFilter() method retrieves a filtered set of customers and their sales orders based on the sales order filters.

For this overload of the method, the filter is based on the input parameters, which are based on the sales order states.

Syntax

'Declaration
 
Public Overloads Shared Function GetByFilter( _
   ByVal openOrders As Boolean, _
   ByVal partialOrders As Boolean, _
   ByVal completeOrders As Boolean _
) As DataSet

'Usage
 
Dim openOrders As Boolean
Dim partialOrders As Boolean
Dim completeOrders As Boolean
Dim value As DataSet
 
value = Cust.GetByFilter(openOrders, partialOrders, completeOrders)

public static DataSet GetByFilter( 
   bool openOrders,
   bool partialOrders,
   bool completeOrders
)

Parameters

openOrders: Required. Holds the flag that indicates whether the open sales orders should be retrieved.
partialOrders: Required. Holds the flag that indicates whether the partial sales orders should be retrieved.
completeOrders: Required. Holds the flag that indicates whether the complete sales orders should be retrieved.

Return Value

Returns a DataSet of customers and purchase orders, based on the specified filters, from columns in the Cust and SO tables. The DataSet records are only for customers (that is, for those records in the Cust table for which the customer flag is true, regardless of the vendor flag setting). If no matching sales order states are found for any customers, an empty DataSet is returned.

The columns of the returned DataSet are described below.

Column Names	Description
cust_id	A string that is the customer ID, from the Cust table.
cust_name	A string that is the name of the customer, from the Cust table.
po_id	A string that is the customer's purchase order ID, from the SO table.

MES Stateless API