USP_SEARCHLIST_PDCOMPOSITESEGMENTVALUE

Returns search list for a specified table.

Parameters

Parameter	Parameter Type	Mode	Description
@PDACCOUNTTABLESAVAILABLEFORSEGMENTID	uniqueidentifier	IN	PDACCOUNTTABLESAVAILABLEFORSEGMENTID
@NAME	nvarchar(512)	IN	Name
@MAXROWS	smallint	IN	Input parameter indicating the maximum number of rows to return.

Definition

Copy



CREATE procedure dbo.USP_SEARCHLIST_PDCOMPOSITESEGMENTVALUE
(
    @PDACCOUNTTABLESAVAILABLEFORSEGMENTID uniqueidentifier,
    @NAME nvarchar(512) = null,
    @MAXROWS smallint = 500
)
as
  --sanitize the search value, adding mask chars at beginning and end so it performs a 'contains' style match

    set @NAME = dbo.UFN_TEXTSEARCH_SANITIZE(@NAME,'/',DEFAULT,DEFAULT,DEFAULT) ;

    select top(@MAXROWS)
        LONGDESCRIPTIONID as ID,
        LONGDESCRIPTION as NAME

    from 
        dbo.PDCOMPOSITESEGMENTMAPPINGVIEW
    where
        PDACCOUNTTABLESAVAILABLEFORSEGMENTID = @PDACCOUNTTABLESAVAILABLEFORSEGMENTID
        and (LONGDESCRIPTION like @NAME escape '/')
    order by 
        NAME asc