USP_CLONESITE_SEARCH

Handles the 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_SEARCH
(
@SourceClientSitesID int,
@TargetClientSitesID int,
@CurrentUserID int,
@CopyBatchGuid uniqueidentifier
)
as

    insert into dbo.SearchPart (SiteContentID, Name, Description, SearchCaption, Guid, SiteSearchType)
    select
    SC.ID,
    SP.Name,
    SP.Description,
    SP.SearchCaption,
    NewID(),
  SP.SiteSearchType
    from dbo.SearchPart SP
    inner join dbo.SiteContent SC on SC.CopySourceID = SP.SiteContentID
    where SC.CopyBatchGuid = @CopyBatchGuid


    --Update XML Data

    declare @Data xml
    set @Data = 
    (
        select P.SiteContentID, SP.ID as Value
        from dbo.UFN_GETXMLPROPERTYFORSITECOPY(@CopyBatchGuid,89, 'SearchPartID') P
        inner join dbo.SearchPart SP on SP.SiteContentID = P.SiteContentID
        FOR XML RAW, ELEMENTS
    )    
    exec USP_UPDATEXMLPROPERTYFORSITECOPY 'SearchPartID', @Data