Emails triggered by Approval of Decision

Hi, 

Yes you can trigger an email to fire on the action processor, we do this by using checkAnswer:

{ 
        [[ Send Mail to affected user Decision Approval Received ]], 
        [[ EVENT_TYPE == "d"
            and ACT_TYPE_SC == "CLOSURE" 
            and (CATEGORY_SC == "DECISION" or
            CATEGORY_SC == "AUTHORIZATION" or 
            CATEGORY_SC == "APPROVALS")
            and checkAnswer("Yes", EVENT_ID) ]], 
         strSendMailV2 .. "TEMPLATE=SM_INTERNAL_APPROVAL_RECEIVED RECIPIENTS=TO_AFFECTED",  
        "continue"  
    },

Hope this helps you. 

Kev

Thanks @KevinM I’ll have a play around with this

Additionally should have added that Check Answer is a function, this is added at the bottom of our action_processor_rules_conf.lua

function checkAnswer(parmAnswer, parmEventId)

    local sSql = [[SELECT
         answer 'ANSWER'
        FROM rproc_task
        INNER JOIN rproc_dtl
        ON rproc_task.rproc_dtl_id = rproc_dtl.rproc_dtl_id
        INNER JOIN rproc_decisions 
        ON (rproc_decisions.rproc_task_id = rproc_task.rproc_task_id
            and rproc_decisions.rproc_decision_id = rproc_task.answer_id)
        WHERE
        rproc_task.incident_id = ]] .. parmEventId
        
    local result,err = DB:sql(sSql)
    if err then 
        LOGGER:error("Error in SQL when checking for Decision Answer. Error: " .. (err or "??") .. "\nSQL: " .. stringify(sSql))
        return
    end
    
    if result['ANSWER']:upper() == parmAnswer:upper() then
        return true
    else
        return false
    end
end

ANSWER_VALUE = ""
function getDecisionAnswer(eventId, actRegId,ans, rmks)
    local actRegId = actRegId or 0
    local ans = ans or ""
    local ok,err = DB:sql([[
            SELECT answer 'ANSWER_VALUE'
            FROM act_reg
            INNER JOIN rproc_task ON rproc_task.incident_id = act_reg.incident_id
            INNER JOIN rproc_dtl ON rproc_dtl.rproc_dtl_id = rproc_task.rproc_dtl_id
            INNER JOIN rproc_decisions ON rproc_task.rproc_task_id = rproc_decisions.rproc_task_id
            WHERE answer = ']] .. ans .. [['
            AND act_reg.act_reg_id = ]] .. actRegId
            )
    if err then 
        LOGGER:error("Error in SQL when checking for Decision Answer. Error: " .. (err or "??"))
        return
    end
    if ok and ok["ANSWER_VALUE"] and (ok["ANSWER_VALUE"] or "") ~= "" then
        local ANSWER_VAR = ok["ANSWER_VALUE"]
        LOGGER:info("Ready to run external command for " .. actRegId .. ": " .. strETMNoUser .. "'ECC Make Decision' EventID='" .. eventId .. "' Answer='" .. ANSWER_VAR .. "' Remarks='" .. rmks .. "';")
        os.execute(strETM .. "'ECC Make Decision' EventID='" .. eventId .. "' Answer='" .. ANSWER_VAR .. "' Remarks='" .. rmks .. "';")
        -- return ok["ANSWER_VALUE"]
        return
    else
        return
    end
end

@KevinM We’ve been trying this but the action processor is really unhappy with some part of it. I’ll keep trying

Since you will only have a single stage created after the Approval, you can use an AP rule to trigger SmartMail based on that stage action on the parent event. The sample rule below could be extended if needed to only send on certain workflows or offerings.

    {
        [[ Send Mail to affected user Decision Approval Received ]], 
        [[ (EVENT_TYPE == "r" or EVENT_TYPE == "s")
            and ACT_TYPE_SC == "POST APPROVAL STAGE SC" 
        ]], 
         strSendMailV2 .. "TEMPLATE=SM_INTERNAL_APPROVAL_RECEIVED RECIPIENTS=TO_AFFECTED",  
        "continue"  
    },