USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTSUMMARYORGANIZATIONCONTACTSTILE
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @CURRENTAPPUSERID | uniqueidentifier | IN | |
| @DATALOADED | bit | INOUT | |
| @CONTACTS | xml | INOUT |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTSUMMARYORGANIZATIONCONTACTSTILE
(
@ID uniqueidentifier,
@CURRENTAPPUSERID uniqueidentifier,
@DATALOADED bit = 0 output,
@CONTACTS xml = null output
)
as
set nocount on;
set @DATALOADED = 0;
select @CONTACTS = dbo.UFN_CONSTITUENT_GETCURRENTCONTACTS_TOITEMLISTXML(@ID, @CURRENTAPPUSERID, '5e10dd1b-4f3f-4787-9032-5b015bd8c030');
if exists(select 1 from dbo.CONSTITUENT where ID = @ID)
set @DATALOADED = 1;
return 0;