UFN_PROSPECTRESEARCHREQUEST_OPENCONSTITUENTS

Returns a table containing IDs of all constituents with an open prospect research request.

Return

Return Type
table

Definition

Copy



            CREATE function dbo.UFN_PROSPECTRESEARCHREQUEST_OPENCONSTITUENTS()
            returns table
            as
            return
            (
                select
                    [PROSPECTRESEARCHREQUESTCONSTITUENT].[CONSTITUENTID] as ID
                from
                    [dbo].[PROSPECTRESEARCHREQUESTCONSTITUENT]
                where
                    [PROSPECTRESEARCHREQUESTCONSTITUENT].[STATUSCODE] in (0, 1, 2, 3)
            )