USP_SIMPLEDATALIST_RELATIONSHIP_IND2ORG

This datalist returns all available individual to organization relationships in the system.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	CONSTITUENTID

Definition

Copy



            CREATE procedure dbo.USP_SIMPLEDATALIST_RELATIONSHIP_IND2ORG(@CONSTITUENTID uniqueidentifier = null)
            as
                set nocount on;

                select
                    RELATIONSHIP.ID as VALUE,
                    RELATIONSHIP.DESCRIPTION as LABEL
                from
                    dbo.RELATIONSHIP
                inner join dbo.CONSTITUENT RELATION
                    on RELATIONSHIPCONSTITUENTID = RELATION.ID
                inner join dbo.CONSTITUENT RECIPROCAL
                    on RECIPROCALCONSTITUENTID = RECIPROCAL.ID
                where RELATIONSHIPCONSTITUENTID = @CONSTITUENTID
                      and
                      (
                        (RELATION.ISORGANIZATION = 0 and RELATION.ISGROUP = 0 and RECIPROCAL.ISORGANIZATION = 1)
                        or
                        (RECIPROCAL.ISORGANIZATION = 0 and RECIPROCAL.ISGROUP = 0 and RELATION.ISORGANIZATION = 1)
                      )
                order by
                    RELATIONSHIP.DESCRIPTION;