USP_DATALIST_PARTIALINFORMATIONSEARCHRESULTS_REALESTATE

Returns a list of real estate results for a search criteria.
Parameters

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

Copy


                CREATE procedure dbo.USP_DATALIST_PARTIALINFORMATIONSEARCHRESULTS_REALESTATE (
                    @PARTIALINFORMATIONSEARCHCRITERIAID uniqueidentifier
                ) as
                    set nocount on;

                    select
                        [ID],
                        case [CONFIDENCE]
                            when '0' then
                                'catalog:Blackbaud.AppFx.WealthPoint.Catalog.dll,Blackbaud.AppFx.WealthPoint.Catalog.level_0_16.png'
                            when '1' then
                                'catalog:Blackbaud.AppFx.WealthPoint.Catalog.dll,Blackbaud.AppFx.WealthPoint.Catalog.level_1_16.png'
                            when '2' then
                                'catalog:Blackbaud.AppFx.WealthPoint.Catalog.dll,Blackbaud.AppFx.WealthPoint.Catalog.level_2_16.png'    
                            when '3' then
                                'catalog:Blackbaud.AppFx.WealthPoint.Catalog.dll,Blackbaud.AppFx.WealthPoint.Catalog.level_3_16.png'
                            when '4' then
                                'catalog:Blackbaud.AppFx.WealthPoint.Catalog.dll,Blackbaud.AppFx.WealthPoint.Catalog.level_4_16.png'         
                            when '5' then
                                'catalog:Blackbaud.AppFx.WealthPoint.Catalog.dll,Blackbaud.AppFx.WealthPoint.Catalog.level_5_16.png'    
                        end as [STATUSICON],
                        [CONFIDENCE],
                        [FIPSCODE],
                        [ASSESSORSPARCELNUMBER],
                        [OWNERNAME],
                        dbo.UFN_PARTIALINFORMATIONSEARCH_BUILDADDRESS(PISRRE.PROPERTYADDRESSBLOCK, PISRRE.PROPERTYUNITNUMBER, PISRRE.PROPERTYCITY, PISRRE.PROPERTYSTATE, PISRRE.PROPERTYPOSTCODE) [PROPERTYADDRESS],
                        dbo.UFN_PARTIALINFORMATIONSEARCH_BUILDADDRESS(PISRRE.MAILINGADDRESSBLOCK, PISRRE.MAILINGUNITNUMBER, PISRRE.MAILINGCITY, PISRRE.MAILINGSTATE, PISRRE.MAILINGPOSTCODE) [MAILINGADDRESS],
                        [MATCHTYPE],
                        case 
                            when PISRRE.MAILINGADDRESSBLOCK <> '' or PISRRE.MAILINGUNITNUMBER <> '' or PISRRE.MAILINGCITY <> '' or PISRRE.MAILINGSTATE <> '' or PISRRE.MAILINGPOSTCODE <> '' then
                                1
                            else
                                0
                        end as [HASMAILINGADDR]
                    from
                        dbo.[PARTIALINFORMATIONSEARCHRESULT_REALESTATE] PISRRE
                    where
                        PISRRE.[PARTIALINFORMATIONSEARCHCRITERIAID] = @PARTIALINFORMATIONSEARCHCRITERIAID
                    order by
                        [CONFIDENCE] desc, [ASSESSORSPARCELNUMBER], [FIPSCODE];