USP_CLONESITE_QUICKSEARCH

Handles the Quick Search part-specific steps for cloning a CMS site.

Parameters

Parameter	Parameter Type	Mode
@SourceClientSitesID	int	IN
@TargetClientSitesID	int	IN
@CurrentUserID	int	IN
@CopyBatchGuid	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_CLONESITE_QUICKSEARCH
(
@SourceClientSitesID int,
@TargetClientSitesID int,
@CurrentUserID int,
@CopyBatchGuid uniqueidentifier
)
as


    insert into dbo.QuickSearchPart (Name, SiteContentID, SearchCaption, DestinationPageID, Guid)
    select
    QSP.Name,
    SC.ID,
    QSP.SearchCaption,
    ISNULL(SP.ID,QSP.DestinationPageID),
    NewID()
    from dbo.QuickSearchPart QSP
    inner join dbo.SiteContent SC on SC.CopySourceID = QSP.SiteContentID
    left outer join dbo.SitePages SP on SP.CopySourceID = QSP.DestinationPageID and SP.CopyBatchGUID = @CopyBatchGuid
    where SC.CopyBatchGUID = @CopyBatchGuid

    --Update XML Data

    declare @Data xml
    set @Data = 
    (
        select P.SiteContentID, QSP.ID as Value
        from dbo.UFN_GETXMLPROPERTYFORSITECOPY(@CopyBatchGuid,90, 'QuickSearchPartID') P
        inner join dbo.QuickSearchPart QSP on QSP.SiteContentID = P.SiteContentID
        FOR XML RAW, ELEMENTS
    )    
    exec USP_UPDATEXMLPROPERTYFORSITECOPY 'QuickSearchPartID', @Data