USP_RECORDOPERATION_GETLIST

Lists record operations from the catalog.

Parameters

Parameter	Parameter Type	Mode	Description
@FilterRecordType	nvarchar(50)	IN
@MaxRows	int	IN

Definition

Copy



CREATE procedure dbo.USP_RECORDOPERATION_GETLIST
    @FilterRecordType nvarchar(50) = '',
    @MaxRows int = 0
as
    set nocount on;
    if (@MaxRows > 0)
        select top(@MaxRows) RECORDOPERATIONCATALOG.ID, RECORDOPERATIONCATALOG.DISPLAYNAME, RECORDOPERATIONCATALOG.DESCRIPTION, COALESCE    (RECORDTYPE.NAME, '') as 'RECORDTYPE', RECORDOPERATIONCATALOG.UINAME
        from dbo.RECORDOPERATIONCATALOG
        left outer join dbo.RECORDTYPE on RECORDOPERATIONCATALOG.RECORDTYPEID = RECORDTYPE.ID
        where ((@FilterRecordType = '') or (RECORDTYPE.NAME = @FilterRecordType))
        order by RECORDOPERATIONCATALOG.UINAME;
    else
        select RECORDOPERATIONCATALOG.ID, RECORDOPERATIONCATALOG.DISPLAYNAME, RECORDOPERATIONCATALOG.DESCRIPTION, COALESCE    (RECORDTYPE.NAME, '') as 'RECORDTYPE', RECORDOPERATIONCATALOG.UINAME
        from dbo.RECORDOPERATIONCATALOG
        left outer join dbo.RECORDTYPE on RECORDOPERATIONCATALOG.RECORDTYPEID = RECORDTYPE.ID
        where ((@FilterRecordType = '') or (RECORDTYPE.NAME = @FilterRecordType))
        order by RECORDOPERATIONCATALOG.UINAME;

    return 0;