V_SEARCH_OPPORTUNITY

Search for Opportunity

Fields

Field	Field Type	Null
ID	uniqueidentifier
LOOKUPID	nvarchar(100)	yes
NAME	nvarchar(154)	yes
DESIGNATION	nvarchar(max)	yes
ASKAMOUNT	money
ASKDATE	datetime	yes
STATUS	nvarchar(16)	yes
PROSPECTPLANNAME	nvarchar(100)	yes
PROSPECTPLANTYPE	nvarchar(100)	yes
TRANSACTIONCURRENCYID	uniqueidentifier	yes

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  9/1/2024 11:54:17 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3800.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SEARCH_OPPORTUNITY AS



                select
                    O.ID,
                    C.LOOKUPID,
                    NF.NAME,
                    coalesce(
                        ltrim(
                            stuff( 
                                (select ', '+ D.NAME
                                from dbo.DESIGNATION D
                                inner join dbo.OPPORTUNITYDESIGNATION OD on D.ID = OD.DESIGNATIONID
                                where OD.OPPORTUNITYID = O.ID
                                for xml path(''))
                            ,1,1,'')
                        )
                    ,'') DESIGNATION,
                    O.TRANSACTIONASKAMOUNT as ASKAMOUNT,
                    O.ASKDATE,
                    O.STATUS,
                    PP.NAME as PROSPECTPLANNAME,
                    dbo.UFN_PROSPECTPLANTYPECODE_GETDESCRIPTION(PP.PROSPECTPLANTYPECODEID) as PROSPECTPLANTYPE,
                    O.TRANSACTIONCURRENCYID
                from
                    dbo.OPPORTUNITY O
                left outer join
                    dbo.PROSPECTPLAN PP on O.PROSPECTPLANID = PP.ID
                left outer join
                    dbo.CONSTITUENT C on PP.PROSPECTID = C.ID
                outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(C.ID) NF