MES Stateless API

GetByFilter Method (Item)

Save PDF

GetByFilter Method (Item)

Save PDF

Last UpdatedNov 06, 2025
1 minute read

The GetByFilter() method retrieves item records from the Item table, as specified by the filter parameters. Passing no filter parameters will retrieve all item records from the table.

Overload List

Overload	Description
GetByFilter(String,String,String,String,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Int32>,Nullable<Boolean>,Nullable<Int32>,Nullable<Double>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Int32>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Int32>,Nullable<Int32>,Nullable<Double>,Nullable<Boolean>,String,String,Nullable<Double>,String,String,Nullable<Int32>,Nullable<Double>,Nullable<Double>,Nullable<Double>,Nullable<Boolean>,String,String,String,String)	The GetByFilter() method retrieves item records from the Item table, as specified by the filter parameters. Passing no filter parameters will retrieve all item records from the table.
GetByFilter(String,String,String,String,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Int32>,Nullable<Boolean>,Nullable<Int32>,Nullable<Double>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Int32>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Int32>,Nullable<Int32>,Nullable<Double>,Nullable<Boolean>,String,String,Nullable<Double>,String,String,Nullable<Int32>,Nullable<Double>,Nullable<Double>,Nullable<Double>,Nullable<Boolean>,String,String,String,String,Nullable<Int32>)	The GetByFilter() overload method retrieves the top N item records from the Item table, as specified by the filter parameters. Passing no filter parameters will retrieve all the item records from the table.

Overload

Description

GetByFilter(String,String,String,String,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Int32>,Nullable<Boolean>,Nullable<Int32>,Nullable<Double>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Int32>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Int32>,Nullable<Int32>,Nullable<Double>,Nullable<Boolean>,String,String,Nullable<Double>,String,String,Nullable<Int32>,Nullable<Double>,Nullable<Double>,Nullable<Double>,Nullable<Boolean>,String,String,String,String)

The GetByFilter() method retrieves item records from the Item table, as specified by the filter parameters. Passing no filter parameters will retrieve all item records from the table.

The GetByFilter() overload method retrieves the top N item records from the Item table, as specified by the filter parameters. Passing no filter parameters will retrieve all the item records from the table.

MES Stateless API