spGetEmailTemplateSearchResults

Parameters

Parameter	Parameter Type	Mode
@clientsID	int	IN
@backOfficeSystemID	int	IN
@name	nvarchar(92)	IN
@description	nvarchar(255)	IN
@subject	nvarchar(255)	IN
@exactOnly	bit	IN
@includeDeleted	bit	IN
Definition

Copy


      CREATE PROCEDURE [dbo].[spGetEmailTemplateSearchResults] 
          (
              @clientsID int,
              @backOfficeSystemID int,
              @name nvarchar(92),
              @description nvarchar(255),
              @subject nvarchar(255),
              @exactOnly bit,
              @includeDeleted bit
          )
      AS
      BEGIN

          if @exactOnly = 'false'
          BEGIN
              SELECT    et.[ID]
                ,et.[Name]
                ,et.[Description]
                ,et.[Subject]
                ,et.[DataSourceID]
              FROM emailtemplate et 
              INNER JOIN DataSources ds on et.DataSourceID = ds.DataSourceID AND ds.Deleted = 0
              WHERE ds.[BackOfficeSystemID] = @backOfficeSystemID
              AND et.[clientsid] = @clientsID
              AND et.[deleted] in (0, @includeDeleted)
              AND et.[name] like '%' + ISNULL(@name, et.name) + '%' 
              AND et.[description]  like '%' + ISNULL(@description, et.description) + '%'
              AND et.[subject]  like '%' + ISNULL(@subject, et.subject) + '%'
              ORDER BY et.[name]
          END
          ELSE
              SELECT    et.[ID]
                ,et.[Name]
                ,et.[Description]
                ,et.[Subject]
                ,et.[DataSourceID]
              FROM emailtemplate et 
              INNER JOIN DataSources ds on et.DataSourceID = ds.DataSourceID AND ds.Deleted = 0
              WHERE ds.[BackOfficeSystemID] = @backOfficeSystemID
              AND et.[clientsid] = @clientsID
              AND et.[deleted] in (0, @includeDeleted)
              AND et.[name] = ISNULL(@name, et.name)  
              AND et.[description]  = ISNULL(@description, et.description) 
              AND et.[subject]  = ISNULL(@subject, et.subject) 
              ORDER BY et.[name]

      END