UFN_CONSTITUENT_GETCURRENTCONTACTS_TOITEMLISTXML
Return
| Return Type |
|---|
| xml |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @RELATIONSHIPCONSTITUENTID | uniqueidentifier | IN | |
| @CURRENTAPPUSERID | uniqueidentifier | IN | |
| @DATAFORMINSTANCEID | uniqueidentifier | IN |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 6/23/2017 11:54:01 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.170.0, Culture=neutral, PublicKeyToken=null
Based on: UFN_CONSTITUENT_GETCURRENTCONTACTS
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_CONSTITUENT_GETCURRENTCONTACTS_TOITEMLISTXML](
@RELATIONSHIPCONSTITUENTID uniqueidentifier
, @CURRENTAPPUSERID uniqueidentifier
, @DATAFORMINSTANCEID uniqueidentifier
)
returns xml
as
BEGIN
RETURN (
SELECT
[CONTACTISDECEASED],
[CONTACTISINACTIVE],
[CONTACTNAME],
[CONTACTTYPE],
[DONOTCALL],
[DONOTEMAIL],
[EMAILADDRESS],
[FIRSTNAME],
[ID],
[ISCONFIDENTIAL],
[ISPRIMARYCONTACT],
[KEYNAME],
[PHONENUMBER],
[USERHASPERMISSIONTOVIEWCONTACT]
FROM dbo.[UFN_CONSTITUENT_GETCURRENTCONTACTS](@RELATIONSHIPCONSTITUENTID, @CURRENTAPPUSERID, @DATAFORMINSTANCEID)
order by ISPRIMARYCONTACT desc,KEYNAME,FIRSTNAME
for xml path('ITEM'),type,elements,root('CONTACTS'),BINARY BASE64
)
END