USP_DATAFORMTEMPLATE_VIEW_PARTIALINFORMATIONSEARCHPAGEEXPRESSIONS

The load procedure used by the view dataform template "Prospect Quick Search Page Expressions View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@SEARCHDATE	datetime	INOUT	Search date
@REALESTATERESULTCOUNT	int	INOUT	Real estate result count
@BUSINESSOWNERSHIPRESULTCOUNT	int	INOUT	Business ownership result count

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PARTIALINFORMATIONSEARCHPAGEEXPRESSIONS (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @SEARCHDATE datetime = null output,
                    @REALESTATERESULTCOUNT int = null output,
                    @BUSINESSOWNERSHIPRESULTCOUNT int = null output
                ) as
                    set nocount on;

                    if @ID = '00000000-0000-0000-0000-000000000001' begin
                        -- this view form should be valid for non-existent searches, so as to be available
                        set @BUSINESSOWNERSHIPRESULTCOUNT = -1
                        set @REALESTATERESULTCOUNT = -1
                        set @DATALOADED = 1;
                    end
                    else begin
                        select
                            @DATALOADED = 1,
                            @SEARCHDATE = PISC.[SEARCHDATE],
                            @REALESTATERESULTCOUNT = (select COUNT(*) from dbo.PARTIALINFORMATIONSEARCHRESULT_REALESTATE PISR_RE where PISR_RE.PARTIALINFORMATIONSEARCHCRITERIAID = PISC.id),
                            @BUSINESSOWNERSHIPRESULTCOUNT = (select COUNT(*) from dbo.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIP PISR_BO where PISR_BO.PARTIALINFORMATIONSEARCHCRITERIAID = PISC.id)
                        from
                            dbo.[PARTIALINFORMATIONSEARCHCRITERIA] PISC
                        where
                            PISC.[ID] = @ID;
                    end

                    return 0;