USP_DATALIST_CONSTITUENCIES_1_1

This datalist returns the user-defined constituencies for a constituent.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@INCLUDEINACTIVE	bit	IN

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_CONSTITUENCIES_1_1 (
                    @ID uniqueidentifier,
                    @CURRENTAPPUSERID uniqueidentifier = null,
                    @INCLUDEINACTIVE bit = 0
                    )
                as
                    set nocount on;

                    select
                        c.ID,
                        c.CONSTITUENCYTYPECODE,
                        c.DESCRIPTION,
                        c.DATEFROM,
                        c.DATETO,
                        c.CONSTITUENCYCODEID,
                        CONSTITUENCYDEFINITION.ISACTIVE
                    from
                        dbo.UFN_CONSTITUENT_GETALLCONSTITUENCIES(@ID) c
                        -- the view should always return all available constituencies, but left joining to ensure Constituent constituencies are never lost.

                        left join dbo.V_CONSTITUENCYDISPLAYORDER on V_CONSTITUENCYDISPLAYORDER.ID = c.CONSTITUENCYCODEID
                        inner join dbo.CONSTITUENCYDEFINITION
                            on CONSTITUENCYDEFINITION.ID = c.CONSTITUENCYCODEID
                    where
                        @INCLUDEINACTIVE = 1
                        or CONSTITUENCYDEFINITION.ISACTIVE = 1
                    order by
                        coalesce(V_CONSTITUENCYDISPLAYORDER.SEQUENCE, 9999), c.DESCRIPTION, c.DATEFROM, c.DATETO, c.CONSTITUENCYTYPECODE;