USP_DASHBOARD_GETLIST
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @FilterRecordType | nvarchar(50) | IN |
Definition
Copy
create procedure dbo.USP_DASHBOARD_GETLIST
@FilterRecordType nvarchar(50) = ''
as
select DASHBOARDCATALOG.ID, DASHBOARDCATALOG.[NAME], DASHBOARDCATALOG.DESCRIPTION, COALESCE(RECORDTYPE.NAME, '') as 'RECORDTYPE'
from dbo.DASHBOARDCATALOG left outer join dbo.RECORDTYPE on DASHBOARDCATALOG.CONTEXTRECORDTYPEID = RECORDTYPE.ID
where ((@FilterRecordType = '') or (RECORDTYPE.NAME = @FilterRecordType))