UFN_PEOPLELINKORGANIZATION_CONTACTS
Gets a table of contacts for a given PEOPLELINKORGANIZATION ID.
Return
Return Type |
---|
table |
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@PEOPLELINKORGANIZATIONID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_PEOPLELINKORGANIZATION_CONTACTS(@PEOPLELINKORGANIZATIONID uniqueidentifier)
returns table
as return
select
ID,
FULLNAME,
RELATIONSHIP
from
dbo.PEOPLELINKCONTACT
where
PEOPLELINKORGANIZATIONID=@PEOPLELINKORGANIZATIONID