USP_RE7PACKAGESEARCH

Parameters

Parameter	Parameter Type	Mode
@DESCRIPTION	nvarchar(255)	IN
@IDENTIFIER	nvarchar(20)	IN
@CATEGORY	int	IN
@SYSTEMRECORDID	int	IN
@MAXROWS	smallint	IN

Definition

Copy



      create procedure dbo.USP_RE7PACKAGESEARCH
      (
      @DESCRIPTION nvarchar(255) = null,
      @IDENTIFIER nvarchar(20) = null,
      @CATEGORY int = null,
      @SYSTEMRECORDID int = null,
      @MAXROWS smallint = 0
      )
      as
      set nocount on;
      set @DESCRIPTION = '%' + isnull(@DESCRIPTION, '') + '%';
      set @IDENTIFIER = '%' + isnull(@IDENTIFIER, '') + '%';

      select  top (@MAXROWS)
      [P].[LOCALID] [ID],
      [P].[NAME] [IDENTIFIER],
      [P].[DESCRIPTION],
      [PC].[DESCRIPTION] [CATEGORY]
      from [dbo].[RE7_PACKAGE] [P]
      left outer join dbo.[RE7_PACKAGECATEGORYCODE] [PC] on [P].[PACKAGECATEGORYCODE_LOCALID] = [PC].[LOCALID]
      where
      (@DESCRIPTION is null or ([P].[DESCRIPTION] like @DESCRIPTION))
      and
      (@IDENTIFIER is null or ([P].[NAME] like @IDENTIFIER))
      and
      (@CATEGORY is null or ([P].[PACKAGECATEGORYCODE_LOCALID] = @CATEGORY))
      and
      (@SYSTEMRECORDID is null or ([P].[LOCALID] = @SYSTEMRECORDID));

      return 0;