UFN_PROSPECTRESEARCHREQUEST_OPENRESEARCHGROUPS

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

Return

Return Type
table

Definition

Copy



            CREATE function dbo.UFN_PROSPECTRESEARCHREQUEST_OPENRESEARCHGROUPS()
            returns table
            as
            return
            (
                select
                    [PROSPECTRESEARCHREQUEST].[RESEARCHGROUPID] as ID
                from
                    [dbo].[PROSPECTRESEARCHREQUEST]
                where
                    [PROSPECTRESEARCHREQUEST].[STATUSCODE] in (0, 1, 2, 3)
            )