USP_SEARCHLIST_FAFDOCUMENT

Search for friends ask friends document

Parameters

Parameter	Parameter Type	Mode	Description
@LIBRARYNAME	nvarchar(100)	IN	Library Name
@DOCUMENTNAME	nvarchar(100)	IN	Document Name
@FILETYPE	nvarchar(100)	IN	Containing File Type
@MAXROWS	smallint	IN	Input parameter indicating the maximum number of rows to return.

Definition

Copy



CREATE procedure dbo.USP_SEARCHLIST_FAFDOCUMENT
(
    @LIBRARYNAME nvarchar(100) = null,
  @DOCUMENTNAME nvarchar(100) = null,
  @FILETYPE nvarchar(100) = null,
    @MAXROWS smallint = 500
)
as

  declare @totalCount int;
    declare @Where nvarchar(500);
  set @Where = '(1)<>0 AND PM.OBJECTGUID is null AND  ((df.Approved=1))';

  if @LIBRARYNAME is not null
    set @Where += ' and sc.Title LIKE ''%' + @LIBRARYNAME + '%''';

  if @DOCUMENTNAME is not null
    set @Where += ' and df.Name LIKE ''%' + @DOCUMENTNAME + '%''';

  if @FILETYPE is not null
    set @Where += ' and df.ContentType LIKE ''%' + @FILETYPE + '%''';

    exec spGetPagedSQL @PKFieldName=N'df.ID',@CKFields=N'',
        @SelectClause=N'df.ID,sc.Title,df.Name,df.Description,df.UploadDate,SUBSTRING(df.ContentType, CHARINDEX(''/'', df.ContentType)+1, LEN(df.ContentType)) AS ContentType,dbo.fnUserName(df.OwnerID) as Owner',
        @FromClause=N'DocUploadFiles AS df INNER JOIN DocUploadPart AS dp ON df.CID = dp.ID INNER JOIN SiteContent AS sc ON dp.SiteContentID = sc.ID left outer join (select PAGEMODELITEM.OBJECTGUID from [dbo].PAGEMODEL inner join [dbo].PAGEMODELITEM on PAGEMODEL.ID = PAGEMODELITEM.PAGEMODELID where PAGEMODEL.LOCKARTIFACTS=1)PM on PM.OBJECTGUID = sc.Guid',
        @WhereClause=@Where,
        @OrderByClause=N'df.Name ASC',@ResultsPerPage=@MAXROWS,@CurrentPage=1,@RowCount=@totalCount output,@Distinct=0