GetItems(String,String,String,Object,Object,Object,Object,String,String,String,String) Method
- Last UpdatedNov 06, 2025
- 2 minute read
The GetItems() method retrieves multiple items and their properties from the database. The method includes the item class ID and flags that indicate produced or consumed items as filter parameters. This overload includes several other optional parameters by which to filter the items being retrieved.
'Declaration
Public Overloads Shared Function GetItems( _
ByVal itemId As String, _
ByVal itemDesc As String, _
ByVal itemClassId As String, _
ByVal produced As Object, _
ByVal consumed As Object, _
ByVal purchased As Object, _
ByVal sold As Object, _
ByVal spare1 As String, _
ByVal spare2 As String, _
ByVal spare3 As String, _
ByVal spare4 As String _
) As DataSet
public static DataSet GetItems(
string itemId,
string itemDesc,
string itemClassId,
object produced,
object consumed,
object purchased,
object sold,
string spare1,
string spare2,
string spare3,
string spare4
)
Parameters
- itemId
- Optional. Holds an item ID by which to filter the items being retrieved. Pass a null to not apply this filter option.
- itemDesc
- Optional. Holds an item description by which to filter the items being retrieved. Pass a null to not apply this filter option.
- itemClassId
- Optional. Holds an item class ID by which to filter the items being retrieved. Pass a null to not apply this filter option.
- produced
Optional. Set to true or false to filter the results according to the state of the item's item class Produced flag. Pass a null to not apply this filter option.
- consumed
Optional. Set to true or false to filter the results according to the state of the item's item class Consumed flag. Pass a null to not apply this filter option.
- purchased
Optional. Holds an object that represents a boolean "purchased" flag. Set the flag to true to filter the results to purchased items. Pass a null to not apply this filter option.
- sold
Optional. Holds an object that represents a boolean "sold" flag. Set the flag to true to filter the results to sold items. Pass a null to not apply this filter option.
- spare1
- Optional. Holds a spare1 value by which to filter the items being retrieved. Pass a null to not apply this filter option.
- spare2
- Optional. Holds a spare2 value by which to filter the items being retrieved. Pass a null to not apply this filter option.
- spare3
- Optional. Holds a spare3 value by which to filter the items being retrieved. Pass a null to not apply this filter option.
- spare4
- Optional. Holds a spare4 value by which to filter the items being retrieved. Pass a null to not apply this filter option.