USP_DATALIST_ASSIGNMENTDOCUMENTATION

This datalist returns all documentation for an assignment.
Parameters

Parameter	Parameter Type	Mode	Description
@ASSIGNMENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@DOCUMENTATIONTYPECODE	tinyint	IN	Documentation type
@TITLE	nvarchar(50)	IN	Title
Definition

Copy


                CREATE procedure dbo.USP_DATALIST_ASSIGNMENTDOCUMENTATION 
                (
                    @ASSIGNMENTID uniqueidentifier = null,
                    @DOCUMENTATIONTYPECODE tinyint = null,
                    @TITLE nvarchar(50) = ''
                )
                as
                    set nocount on;

                    select    
                        ASSIGNMENTMEDIALINK.ID,
                        'c1cf051d-3862-4a3f-b8db-914cd866f487' as [VIEWFORMID],
                        1 as [DOCUMENTATIONTYPECODE],
                        ASSIGNMENTMEDIALINK.MEDIAURL,
                        null,
                        null,
                        'Media link' as [DOCUMENTATIONTYPE],
                        ASSIGNMENTMEDIALINK.TITLE,
                        CAST(ASSIGNMENTMEDIALINK.ID AS NVARCHAR(36)) + ':1'  AS RSSID
                    from
                        dbo.ASSIGNMENTMEDIALINK
                    where 
                        ASSIGNMENTMEDIALINK.ASSIGNMENTID = @ASSIGNMENTID and
                        (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 1) and
                        (@TITLE = '' or ASSIGNMENTMEDIALINK.TITLE like @TITLE + '%')                        
                    union all                
                    select    
                        ASSIGNMENTATTACHMENT.ID,
                        '7c809260-0498-4e5b-bae7-819eef1d53f8' as [VIEWFORMID],
                        2 as [DOCUMENTATIONTYPECODE],
                        null,
                        ASSIGNMENTATTACHMENT.FILENAME,
                        'FILE',
                        'Attachment' as [DOCUMENTATIONTYPE],
                        ASSIGNMENTATTACHMENT.TITLE,
                        CAST(ASSIGNMENTATTACHMENT.ID AS NVARCHAR(36)) + ':2'  AS RSSID
                    from
                        dbo.ASSIGNMENTATTACHMENT
                    where 
                        ASSIGNMENTATTACHMENT.ASSIGNMENTID = @ASSIGNMENTID and
                        (@DOCUMENTATIONTYPECODE is null or @DOCUMENTATIONTYPECODE = 2) and
                        (@TITLE = '' or ASSIGNMENTATTACHMENT.TITLE like @TITLE + '%');