USP_DATALIST_DESIGNATION_HIERARCHY_2
This returns the complete designation hierarchy (previous version returned one level/node at a time).
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ACTIVEONLY | bit | IN | Only show active hierarchies |
| @DESIGNATIONID | uniqueidentifier | IN | Input parameter indicating the context ID for the data list. |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_DESIGNATION_HIERARCHY_2 (
@ACTIVEONLY bit = null
,@DESIGNATIONID uniqueidentifier
)
as
set nocount on;
exec dbo.USP_DESIGNATION_GETHIERARCHY @ACTIVEONLY
,@DESIGNATIONID