USP_DATALISTCATALOG_FINDBYNAME

Returns a list of data lists that match the provided name and to which the given user has rights.

Parameters

Parameter	Parameter Type	Mode	Description
@APPUSERID	uniqueidentifier	IN
@DATALISTNAME	nvarchar(100)	IN

Definition

Copy



CREATE procedure dbo.USP_DATALISTCATALOG_FINDBYNAME(@APPUSERID uniqueidentifier,
    @DATALISTNAME nvarchar(100))
as
    set nocount on;

    declare @ISSYSADMIN bit;

    select @ISSYSADMIN = ISSYSADMIN from dbo.APPUSER where ID = @APPUSERID;

    select DATALISTCATALOG.ID,
        DATALISTCATALOG.UINAME 
    from dbo.DATALISTCATALOG
    where DATALISTCATALOG.UINAME like @DATALISTNAME + '%'
        and (@ISSYSADMIN = 1 or dbo.UFN_SECURITY_APPUSER_GRANTED_DATALIST_IN_SYSTEMROLE(@APPUSERID, DATALISTCATALOG.ID) = 1)
        and 1 = dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED
        (
            DATALISTCATALOG.DATALISTSPEC.query
                (
                    'declare namespace common="bb_appfx_commontypes";
                    /*/common:InstalledProductList'
                )
        )
    order by DATALISTCATALOG.UINAME;