USP_CUSTOMFORMENTRYEXPORTALL

Returns all entries to be exported.

Parameters

Parameter Parameter Type Mode Description
@WHERECLAUSE nvarchar(1200) IN

Definition

Copy


CREATE procedure dbo.USP_CUSTOMFORMENTRYEXPORTALL(@WHERECLAUSE nvarchar(1200))
as
begin

  declare @sqlString nvarchar(1300)

  set @sqlString = 'SELECT ENTRYID, USERNAME FROM dbo.vwCustomFormEntries WHERE ' + @WHERECLAUSE + ' ORDER BY TITLE'

  EXECUTE (@sqlString)

end