USP_DATALIST_FEEDALERTINSTANCE

Returns a list of system instances for a feed alert list.

Parameters

Parameter	Parameter Type	Mode	Description
@ALERTTYPEID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                create procedure dbo.USP_DATALIST_FEEDALERTINSTANCE
                (
                    @ALERTTYPEID uniqueidentifier
                )
                as

                set nocount on;

                select
                    FEEDALERTINSTANCE.ID,
                    FEEDALERTINSTANCE.NAME,
                    (select count(*) from dbo.APPUSERFEEDALERTINSTANCE where FEEDALERTINSTANCEID = FEEDALERTINSTANCE.ID) as [USERCOUNT],
                    FEEDALERTINSTANCE.ISENABLED
                from dbo.FEEDALERTINSTANCE
                where FEEDALERTINSTANCE.ALERTTYPEID = @ALERTTYPEID 
                    and FEEDALERTINSTANCE.ISUSERINSTANCE = 0
                order by FEEDALERTINSTANCE.NAME