USP_SIMPLEDATALIST_PROSPECTRESEARCHREQUESTQUEUEFUNDRAISER

Returns a list of all fundraisers that have a prospect research request that is not completed.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_PROSPECTRESEARCHREQUESTQUEUEFUNDRAISER(
                    @CURRENTAPPUSERID uniqueidentifier
                )
                as
                    select distinct
                        PRR.ASSIGNEDTOID as VALUE, 
                        NF.NAME as LABEL
                    from 
                        dbo.PROSPECTRESEARCHREQUEST PRR
                    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(PRR.ASSIGNEDTOID) NF
                    left join dbo.APPUSER AU on PRR.ASSIGNEDTOID = AU.CONSTITUENTID
                    left join dbo.PROSPECTRESEARCHREQUESTAPPUSERPERMISSION PRRAUP on PRRAUP.ID = @CURRENTAPPUSERID
                    where
                        PRR.ASSIGNEDTOID is not null and
                        (AU.ID = @CURRENTAPPUSERID or PRRAUP.CANVIEWREQUESTSASSIGNEDTOOTHERS = 1)        
                    union
                    select distinct
                        PRRC.ASSIGNEDTOID as VALUE, 
                        NF.NAME as LABEL
                    from 
                        dbo.PROSPECTRESEARCHREQUESTCONSTITUENT PRRC
                    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(PRRC.ASSIGNEDTOID) NF
                    left join dbo.APPUSER AU on PRRC.ASSIGNEDTOID = AU.CONSTITUENTID
                    left join dbo.PROSPECTRESEARCHREQUESTAPPUSERPERMISSION PRRAUP on PRRAUP.ID = @CURRENTAPPUSERID
                    where
                        PRRC.ASSIGNEDTOID is not null and
                        (AU.ID = @CURRENTAPPUSERID or PRRAUP.CANVIEWREQUESTSASSIGNEDTOOTHERS = 1)
                    order by LABEL