USP_DATALIST_DESIGNATION_HIERARCHY_ALL
Returns all of the designation hierarchies.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ACTIVEONLY | bit | IN | Only show active hierarchies |
| @COMBINEDSEARCH | nvarchar(200) | IN | |
| @DESIGNATIONLEVELTYPEID | uniqueidentifier | IN | |
| @SORTFIELD | tinyint | IN | |
| @SORTDIR | tinyint | IN |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_DESIGNATION_HIERARCHY_ALL (
@ACTIVEONLY bit = null
,@COMBINEDSEARCH nvarchar(200) = null
,@DESIGNATIONLEVELTYPEID uniqueidentifier = null
,@SORTFIELD tinyint = null
,@SORTDIR tinyint = null
)
as
set nocount on;
declare @SORTIDX int = 0;
set @SORTDIR = COALESCE(@SORTDIR, 0);
-- passing null returns all hierarchies
exec dbo.USP_DESIGNATION_GETHIERARCHY @ACTIVEONLY = @ACTIVEONLY
,@DESIGNATIONID = null
,@DESIGNATIONLEVELNAME = null
,@DESIGNATIONLEVELTYPEID = @DESIGNATIONLEVELTYPEID
,@LOOKUPID = null
,@COMBINEDSEARCH = @COMBINEDSEARCH
,@SORTFIELD = @SORTFIELD
,@SORTDIR = @SORTDIR;