GetCategoryItemsHierarchy Method
- Last UpdatedNov 06, 2025
- 1 minute read
The GetCategoryItemsHierarchy() method retrieves a list of categories and items in a hierarchical order to build a tree in UI.
'Declaration
Public Shared Function GetCategoryItemsHierarchy( _
ByVal categoryId As Nullable(Of Integer), _
ByVal obsolete As Nullable(Of Boolean) _
) As DataSet
'Usage
Dim categoryId As Nullable(Of Integer)
Dim obsolete As Nullable(Of Boolean)
Dim value As DataSet
value = Item.GetCategoryItemsHierarchy(categoryId, obsolete)
public static DataSet GetCategoryItemsHierarchy(
Nullable<int> categoryId,
Nullable<bool> obsolete
)
Parameters
- categoryId
- Optional. Holds a category id.
- obsolete
- Optional. Holds the obsolete status of an item.
Return Value
Returns a DataSet of categories and items in a hierarchical order related to the category id and obsolete input parameter. If no matching records are found, an empty DataSet is returned.
The columns of the returned DataSet are described below.
|
Column |
Description |
|---|---|
|
category_id |
An integer that is the ID of the category to which the item belongs. |
|
category_name |
A string that is the name of the category from Category table. |
|
item_id |
A string that is the ID of the item. |
|
item_desc |
A string that is the description of the item. |
|
item_display |
A string that is formatted as specified by attr_id=210. |