USP_DATALIST_SPONSORSHIPOPPORTUNITYCHILDRELATIONSHIP
This datalist returns a list of all relationships for a sponsorship opportunity child.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONSTITUENTID | uniqueidentifier | IN | Input parameter indicating the context ID for the data list. |
| @ONLYCURRENT | bit | IN | Only display current relationships |
| @RECIPROCALTYPECODEID | uniqueidentifier | IN | Relationship type |
| @ONLYCONTACTS | bit | IN | Only display contacts |
| @SHOWINDIVIDUALS | bit | IN | Individuals |
| @SHOWORGANIZATIONS | bit | IN | Organizations |
| @SHOWGROUPS | bit | IN | Groups |
| @SHOWHOUSEHOLDS | bit | IN | Households |
Definition
Copy
create procedure dbo.USP_DATALIST_SPONSORSHIPOPPORTUNITYCHILDRELATIONSHIP
(
@CONSTITUENTID uniqueidentifier,
@ONLYCURRENT bit = 0,
@RECIPROCALTYPECODEID uniqueidentifier = null,
@ONLYCONTACTS bit = 0,
@SHOWINDIVIDUALS bit = 1,
@SHOWORGANIZATIONS bit = 1,
@SHOWGROUPS bit = 1,
@SHOWHOUSEHOLDS bit = 1
)
as
set nocount on;
exec dbo.USP_DATALIST_RELATIONSHIPS_ALLTOALL @CONSTITUENTID,@ONLYCURRENT,@RECIPROCALTYPECODEID,@ONLYCONTACTS,@SHOWINDIVIDUALS,@SHOWORGANIZATIONS,@SHOWGROUPS,@SHOWHOUSEHOLDS