USP_DATALIST_COMBINATIONCONSTITUENCY

Displays a list of allowed constituency codes for a combination.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_COMBINATIONCONSTITUENCY
(
    @COMBINATIONID uniqueidentifier,
    @INCLUDEINACTIVE bit = 0
)
as
    set nocount on;

    select
        COMBINATIONCONSTITUENCY.ID,
        isnull(SYSTEMCONSTITUENCYDEFINITION.DESCRIPTION, USERDEFINEDCONSTITUENCYDEFINITION.DESCRIPTION) as [DESCRIPTION],
        case
            when SYSTEMCONSTITUENCYDEFINITION.ISACTIVE = 1
                then 1
            when USERDEFINEDCONSTITUENCYDEFINITION.ISACTIVE = 1
                then 1
            else
                0
        end as ACTIVE
    from dbo.COMBINATIONCONSTITUENCY
        left join dbo.CONSTITUENCYDEFINITION as SYSTEMCONSTITUENCYDEFINITION
            on SYSTEMCONSTITUENCYDEFINITION.ID = COMBINATIONCONSTITUENCY.CONSTITUENCYSYSTEMNAMEID
        left join dbo.CONSTITUENCYDEFINITION as USERDEFINEDCONSTITUENCYDEFINITION
            on USERDEFINEDCONSTITUENCYDEFINITION.ID = COMBINATIONCONSTITUENCY.CONSTITUENCYCODEID
    where
        COMBINATIONID = @COMBINATIONID
        and (
            @INCLUDEINACTIVE = 1
            or (
                SYSTEMCONSTITUENCYDEFINITION.ISACTIVE = 1
                or USERDEFINEDCONSTITUENCYDEFINITION.ISACTIVE = 1
            )
        )
    order by COMBINATIONCONSTITUENCY.SEQUENCE;

    return 0;