USP_PARTIALINFORMATIONSEARCHCRITERIA_GETCONFIGURATIONINFO

This procedure is used to get the configuration info for Prospect Quick Search.

Parameters

Parameter	Parameter Type	Mode
@CLARIFYSITEID	nvarchar(50)	INOUT
@PARTIALINFORMATIONSEARCHURL	UDT_WEBADDRESS	INOUT
@SAVEDSEARCHESPERAPPUSER	int	INOUT

Definition

Copy



            CREATE procedure dbo.USP_PARTIALINFORMATIONSEARCHCRITERIA_GETCONFIGURATIONINFO (
                @CLARIFYSITEID nvarchar(50) = null output,
                @PARTIALINFORMATIONSEARCHURL dbo.UDT_WEBADDRESS = null output,
                @SAVEDSEARCHESPERAPPUSER integer = null output
            ) as
                set nocount on;

                select top 1
                    @CLARIFYSITEID = II.[CLARIFYSITEID]
                from
                    dbo.[INSTALLATIONINFO] II;

                select top 1
                    @PARTIALINFORMATIONSEARCHURL = PISC.[PARTIALINFORMATIONSEARCHURL],
                    @SAVEDSEARCHESPERAPPUSER = PISC.[SAVEDSEARCHESPERAPPUSER]
                from
                    dbo.[PARTIALINFORMATIONSEARCHCONFIGURATION] PISC;


                return 0;