USP_DATALIST_CONSTITUENTPROFILEDASHBOARDCONSTITUENCIES

This datalist returns constituency information that is used by the constituent profile dashboard.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Constituent
@ISVISIBLE	bit	IN	Visible

Definition

Copy



                    CREATE procedure dbo.USP_DATALIST_CONSTITUENTPROFILEDASHBOARDCONSTITUENCIES
                    (
                        @CONSTITUENTID uniqueidentifier,
                        @ISVISIBLE bit = 1
                    )
                    as
                        set nocount on;

                        if @ISVISIBLE = 1
                        begin

                            select
                                CONSTITUENCYTYPECODE,
                                DESCRIPTION,
                                DATEFROM,
                                DATETO
                            from
                                dbo.UFN_CONSTITUENT_GETALLCONSTITUENCIES(@CONSTITUENTID)
                            order by
                                DESCRIPTION, DATEFROM, DATETO, CONSTITUENCYTYPECODE;
                        end