USP_DATALIST_CONDITIONBLOCKS

Returns a list of conditions contained by a conditional content block.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_CONDITIONBLOCKS
                (
                @ID int
                )
                as
                set nocount on;

                select 
                    CONDITIONBLOCKCONDITION.ID,
                    CONDITIONBLOCKCONDITION.CONDITIONBLOCKID,
                    CONDITIONBLOCKCONDITION.CONDITIONID,
                    CONDITIONBLOCKCONDITION.PRIORITY
                from 
                    dbo.CONDITIONBLOCK
                join dbo.CONDITIONBLOCKCONDITION on CONDITIONBLOCK.ID = CONDITIONBLOCKCONDITION.CONDITIONBLOCKID
                where 
                    CONDITIONBLOCK.ID = @ID
                order by CONDITIONBLOCKCONDITION.PRIORITY asc