USP_DATALIST_NAMINGOPPORTUNITIES

This datalist returns the naming opportunities associated with a plan opportunity

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_NAMINGOPPORTUNITIES
                (
                    @OPPORTUNITYID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        NAMINGOPPORTUNITY.ID,
                        NAMINGOPPORTUNITYMGOPPORTUNITY.ID as [MGOPPORTUNITYLINKID],
                        NAMINGOPPORTUNITY.NAME,
                        case when (
                                    select
                                        count([REC].ID)
                                    from dbo.NAMINGOPPORTUNITYRECOGNITION as [REC]
                                    inner join dbo.NAMINGOPPORTUNITYRECOGNITIONMGLINK on NAMINGOPPORTUNITYRECOGNITIONMGLINK.NAMINGOPPORTUNITYRECOGNITIONID = [REC].ID
                                    inner join dbo.NAMINGOPPORTUNITYMGOPPORTUNITY on NAMINGOPPORTUNITYMGOPPORTUNITY.ID = NAMINGOPPORTUNITYRECOGNITIONMGLINK.MGOPPORTUNITYLINKID
                                    where
                                        [REC].NAMINGOPPORTUNITYID = NAMINGOPPORTUNITY.ID
                                        and NAMINGOPPORTUNITYMGOPPORTUNITY.OPPORTUNITYID = @OPPORTUNITYID
                                    )
                                 > 0 then 1 else 0 end as [RECOGNIZED]

                    from dbo.NAMINGOPPORTUNITY
                    inner join dbo.NAMINGOPPORTUNITYMGOPPORTUNITY on NAMINGOPPORTUNITYMGOPPORTUNITY.NAMINGOPPORTUNITYID = NAMINGOPPORTUNITY.ID
                    where
                        NAMINGOPPORTUNITYMGOPPORTUNITY.OPPORTUNITYID = @OPPORTUNITYID;