USP_DATALIST_ADDRESSBOOKCONTACTSEARCH
Return a list of Address Book contacts that match the current search string
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CLIENTUSERSID | int | IN | Client Users ID |
| @SEARCHSTRING | varchar(50) | IN | Search String |
| @ONLYSEARCHLASTNAME | bit | IN | |
| @LASTNAME | varchar(100) | IN | |
| @FIRSTNAME | varchar(50) | IN | |
| @EMAILADDRESS | varchar(100) | IN |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_ADDRESSBOOKCONTACTSEARCH
(
@CLIENTUSERSID int,
@SEARCHSTRING varchar(50) = '',
@ONLYSEARCHLASTNAME bit = 0,
@LASTNAME varchar(100) = null,
@FIRSTNAME varchar(50) = null,
@EMAILADDRESS varchar(100) = null
)
as
set nocount on;
select distinct(AB.ID), ltrim(rtrim(replace(isnull(AB.FIRSTNAME+' ', '') + isnull(AB.LASTNAME, ''), ' ', ' '))) as KEYNAME,
Case When RE.ALLOWOTHERPARTICIPANTSCONTACTME is null then 1 else RE.ALLOWOTHERPARTICIPANTSCONTACTME end,
isnull(AB.LASTNAME, ''), isnull(AB.FIRSTNAME, ''), isnull(AB.EMAILADDRESS, '')
from dbo.ADDRESSBOOKFAF AB
left outer join registrant R on R.constituentID = AB.ConstituentID
left outer join REGISTRANTEXTENSION RE on R.ID = RE.REGISTRANTID
where CLIENTUSERSID in (select CLIENTUSERID from dbo.UFN_CLIENTUSERS_GETIDLISTBYCURRENTCLIENTUSERID(@CLIENTUSERSID))
and (LASTNAME like @SEARCHSTRING + '%'
or (@ONLYSEARCHLASTNAME = 0 and (ltrim(rtrim(isnull(FIRSTNAME+' ', '') + isnull(LASTNAME, ''))) like @SEARCHSTRING + '%'
or FIRSTNAME like @SEARCHSTRING + '%')))
and LASTNAME = ISNULL(@LASTNAME,LASTNAME)
and FIRSTNAME = ISNULL(@FIRSTNAME,FIRSTNAME)
and EMAILADDRESS = ISNULL(@EMAILADDRESS ,EMAILADDRESS)