USP_DATALIST_ACTION_ITEM_PETITION

Returns all Action Item Petition records.

Parameters

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

Definition

Copy



create procedure dbo.USP_DATALIST_ACTION_ITEM_PETITION
(
        @ACTIONITEMID uniqueidentifier = NULL
)
as
    set nocount on;

    select 
        ACTIONITEMPETITION.[ID],
        ACTIONITEMPETITION.[ACTIONITEMID],
        ACTIONITEMPETITION.[GOAL],
        ACTIONITEMPETITION.PETITIONCOUNT,
        ACTIONITEMPETITION.[MINCOUNT],
        ACTIONITEMPETITION.[STARTCOUNT],
        ACTIONITEMPETITION.[SIGNATUREDISPLAY],
        ACTIONITEMPETITION.[HIDEADVOCATEMESSAGE],
        ACTIONITEMPETITION.[THERMOMETERDISPLAY],
        ACTIONITEMPETITION.[COUNTDISPLAY],
        ACTIONITEMPETITION.[THERMOMETERTYPECODE],
        ACTIONITEMPETITION.[THERMOMETERPOSITIONCODE],
        ACTIONITEMPETITION.[INCLUDEPETITIONCOUNT],
        ACTIONITEMPETITION.[SIGNATUREDISPLAYLABEL],
        ACTIONITEMPETITION.INCLUDEPETITIONDEADLINE,
        ACTIONITEMPETITION.DEADLINETEXT,
        ACTIONITEMPETITION.DEADLINEDATE
    from 
        dbo.ACTIONITEMPETITION
        WHERE ACTIONITEMID = ISNULL(@ACTIONITEMID,ACTIONITEMID)