USP_DATALIST_SMARTQUERYDEFINITION

Returns a list of smart query definitions.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@RECORDTYPEID	uniqueidentifier	IN	Type

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_SMARTQUERYDEFINITION(
                    @CURRENTAPPUSERID uniqueidentifier,
                    @RECORDTYPEID uniqueidentifier = null
                )
                with execute as caller
                as
                    set nocount on;

                    select V_INSTALLED_SMARTQUERYCATALOG.ID, 
                        V_INSTALLED_SMARTQUERYCATALOG.UINAME as NAME, 
                        V_INSTALLED_SMARTQUERYCATALOG.DESCRIPTION, 
                        RECORDTYPE.NAME 'RECORDTYPE'
                    from dbo.V_INSTALLED_SMARTQUERYCATALOG
                        inner join dbo.RECORDTYPE on V_INSTALLED_SMARTQUERYCATALOG.RECORDTYPEID = RECORDTYPE.ID
                    where V_INSTALLED_SMARTQUERYCATALOG.PRIMARYKEYFIELD is not null
                        and (@RECORDTYPEID is null or RECORDTYPE.ID = @RECORDTYPEID)
                        and (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1
                            or dbo.UFN_SECURITY_APPUSER_GRANTED_SMARTQUERY_IN_SYSTEMROLE(@CURRENTAPPUSERID,V_INSTALLED_SMARTQUERYCATALOG.ID) = 1
                        )
                    order by RECORDTYPE.NAME, V_INSTALLED_SMARTQUERYCATALOG.UINAME;