USP_DATALIST_ACTION_ITEM_MESSAGE_TEXT

Returns Action Item Message Text records.

Parameters

Parameter	Parameter Type	Mode	Description
@ACTIONITEMID	uniqueidentifier	IN	Action Item ID
@MESSAGETEXTID	uniqueidentifier	IN	Action Item Message Text ID

Definition

Copy



CREATE procedure dbo.USP_DATALIST_ACTION_ITEM_MESSAGE_TEXT
    (@ACTIONITEMID uniqueidentifier, @MESSAGETEXTID uniqueidentifier = NULL) with execute as owner
as
    set nocount on;

    select 
    ACTIONITEMMESSAGETEXT.[ID],
    ACTIONITEMMESSAGETEXT.[ACTIONITEMID],
    ACTIONITEMMESSAGETEXT.[SUBJECT],
    ACTIONITEMMESSAGETEXT.[MESSAGETEXT],
    ACTIONITEMMESSAGETEXT.[INSTRUCTIONS],
    ACTIONITEMMESSAGETEXT.[THANKYOUMESSAGETEXT],
    ACTIONITEMMESSAGETEXT.[SENDCOPYTONPO],
        ACTIONITEMMESSAGETEXT.[OVERWRITECODE],
        ACTIONITEMMESSAGETEXT.[OVERWRITE],
--        ACTIONITEMMESSAGETEXT.[THANKYOUEMAILSUBJECT],

--        ACTIONITEMMESSAGETEXT.[THANKYOUEMAILTEXT],

        ACTIONITEMMESSAGETEXT.[PERSONALIZATIONCODE],
        ACTIONITEMMESSAGETEXT.[PERSONALIZATION],
    ACTIONITEMMESSAGETEXT.[EMAILTEMPLATEID]
    from 
        dbo.ACTIONITEMMESSAGETEXT (NOLOCK)
    where
        ACTIONITEMMESSAGETEXT.[ACTIONITEMID] = @ACTIONITEMID AND ACTIONITEMMESSAGETEXT.[ID] = ISNULL(@MESSAGETEXTID,ACTIONITEMMESSAGETEXT.[ID])