USP_DATALIST_DESIGNATIONWEBDOCUMENT

This datalist returns all web documents for a designation.

Parameters

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

Definition

Copy



create procedure dbo.USP_DATALIST_DESIGNATIONWEBDOCUMENT(@DESIGNATIONID uniqueidentifier)
as
    set nocount on;

    select ID,
           1 as [DOCUMENTTYPECODE],
           'Details page URL' as [DOCUMENTTYPE],
       DETAILSURL as [DETAILSURL]
    from dbo.DESIGNATIONDETAILSLINK
    where DESIGNATIONID = @DESIGNATIONID

  union

    select ID,
           2 as [DOCUMENTTYPECODE],
           'Thumbnail image' as [DOCUMENTTYPE],
       null as [DETAILSURL]
    from dbo.DESIGNATIONIMAGE
    where DESIGNATIONID = @DESIGNATIONID