USP_SEARCH_KPICATALOG
Search for a KPI type
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @NAME | nvarchar(100) | IN | Name |
| @CONTEXTRECORDTYPEID | uniqueidentifier | IN | Context record type |
| @GOALTYPECODE | tinyint | IN | Goal type |
| @MAXROWS | smallint | IN | Input parameter indicating the maximum number of rows to return. |
Definition
Copy
CREATE procedure dbo.USP_SEARCH_KPICATALOG
(
@NAME nvarchar(100) = null,
@CONTEXTRECORDTYPEID uniqueidentifier = null,
@GOALTYPECODE tinyint = null,
@MAXROWS smallint = 500
)
as
set nocount on;
set @NAME = dbo.UFN_SEARCHCRITERIA_GETLIKEPARAMETERVALUE(@NAME, 0, null);
select top(@MAXROWS)
V_INSTALLED_KPICATALOG.ID,
V_INSTALLED_KPICATALOG.NAME,
V_INSTALLED_KPICATALOG.NAME CONTEXTRECORDTYPE,
V_INSTALLED_KPICATALOG.GOALTYPE
from dbo.V_INSTALLED_KPICATALOG
left join dbo.RECORDTYPE on V_INSTALLED_KPICATALOG.CONTEXTRECORDTYPEID = RECORDTYPE.ID
where (@NAME is null or V_INSTALLED_KPICATALOG.NAME like @NAME)
and (@CONTEXTRECORDTYPEID is null or V_INSTALLED_KPICATALOG.CONTEXTRECORDTYPEID = @CONTEXTRECORDTYPEID)
and (@GOALTYPECODE is null or V_INSTALLED_KPICATALOG.GOALTYPECODE = @GOALTYPECODE)
order by V_INSTALLED_KPICATALOG.NAME;