USP_DATALIST_DESIGNATION_HIERARCHY_BY_DESIGNATION
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ACTIVEONLY | bit | IN | |
| @ROOTDESIGNATIONID | uniqueidentifier | IN | |
| @COMBINEDSEARCH | nvarchar(200) | IN | |
| @DESIGNATIONLEVELTYPEID | uniqueidentifier | IN | |
| @SORTFIELD | tinyint | IN | |
| @SORTDIR | tinyint | IN | |
| @DESIGNATIONREPORT1CODEID | uniqueidentifier | IN | |
| @DESIGNATIONREPORT2CODEID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_DESIGNATION_HIERARCHY_BY_DESIGNATION (
@ACTIVEONLY bit = null
,@ROOTDESIGNATIONID uniqueidentifier = null
,@COMBINEDSEARCH nvarchar(200) = null
,@DESIGNATIONLEVELTYPEID uniqueidentifier = null
,@SORTFIELD tinyint = null
,@SORTDIR tinyint = null
,@DESIGNATIONREPORT1CODEID uniqueidentifier = null
,@DESIGNATIONREPORT2CODEID uniqueidentifier = 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 = @ROOTDESIGNATIONID
,@DESIGNATIONLEVELNAME = null
,@DESIGNATIONLEVELTYPEID = @DESIGNATIONLEVELTYPEID
,@LOOKUPID = null
,@COMBINEDSEARCH = @COMBINEDSEARCH
,@SORTFIELD = @SORTFIELD
,@SORTDIR = @SORTDIR
,@DESIGNATIONREPORT1CODEID = @DESIGNATIONREPORT1CODEID
,@DESIGNATIONREPORT2CODEID = @DESIGNATIONREPORT2CODEID;