USP_DATALIST_CONSTITUENTINTEREST

This datalist returns all interests for a constituent.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



            create procedure dbo.USP_DATALIST_CONSTITUENTINTEREST (@CONSTITUENTID uniqueidentifier)
            as
                set nocount on;

                select 
                   CONSTITUENTINTEREST.ID, 
                   CONSTITUENTINTERESTCODE.DESCRIPTION as TYPE,  
                   CONSTITUENTINTEREST.NOTE
                from 
                   dbo.CONSTITUENTINTEREST 
                inner join 
                   dbo.CONSTITUENTINTERESTCODE on CONSTITUENTINTEREST.CONSTITUENTINTERESTCODEID = CONSTITUENTINTERESTCODE.ID
                where 
                   CONSTITUENTID = @CONSTITUENTID
                order by 
                   CONSTITUENTINTERESTCODE.DESCRIPTION