USP_SIMPLEDATALIST_ATTRIBUTECATEGORIES

A simple data list of attribute categories for a specific record type.

Parameters

Parameter	Parameter Type	Mode	Description
@RECORDTYPE	nvarchar(100)	IN
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



            CREATE procedure dbo.USP_SIMPLEDATALIST_ATTRIBUTECATEGORIES
            (
                @RECORDTYPE nvarchar(100) = '',
                @CURRENTAPPUSERID uniqueidentifier = null  
            ) 
            as                
                set nocount on;

                select   
                    ATTRIBUTECATEGORY.ID as VALUE,   
                    ATTRIBUTECATEGORY.NAME as LABEL   
                from   
                    dbo.ATTRIBUTECATEGORY  
                    inner join dbo.ATTRIBUTERECORDTYPE on ATTRIBUTERECORDTYPE.ID = ATTRIBUTECATEGORY.ATTRIBUTERECORDTYPEID  
                    inner join dbo.RECORDTYPE on RECORDTYPE.ID = ATTRIBUTERECORDTYPE.RECORDTYPEID  
                where   
                    RECORDTYPE.NAME = @RECORDTYPE and
                    dbo.UFN_SECURITY_APPUSER_GRANTED_ATTRIBUTECATEGORY_IN_SYSTEMROLE(@CURRENTAPPUSERID,ATTRIBUTECATEGORY.ID) = 1 and
                    ATTRIBUTECATEGORY.FLAGGEDFORDELETE = 0
                order by   
                    ATTRIBUTECATEGORY.NAME;