contentProcess.js

import("system.vars");
import("system.logging");
import("system.result");
import("system.util");
import("system.db");

logging.log(" -> etz warad i im condition....");

var ret = [];

var campaignstepid = vars.get("$param.campaignStepId_param");
var newParticipants = vars.get("$param.campaignParticipants_param");

var query = "select MAXPARTICIPANTS, count(CAMPAIGNPARTICIPANTID) from CAMPAIGNSTEP "
          + "join CAMPAIGNPARTICIPANT on CAMPAIGNPARTICIPANT.CAMPAIGNSTEP_ID = CAMPAIGNSTEP.CAMPAIGNSTEPID "
          + "where CAMPAIGNSTEP_ID = '" + campaignstepid + "'"
          + "group by CAMPAIGNPARTICIPANT.CAMPAIGNSTEP_ID, MAXPARTICIPANTS";

var maxCurrentParticipants = db.table(query);

if(maxCurrentParticipants.length > 0)
{
    logging.log("hallo2");
    ret[0] = [util.getNewUUID(), "Current Participants", maxCurrentParticipants[0][1], 0];
    ret[1] = [util.getNewUUID(), "New Participants", newParticipants, 0];
    ret[2] = [util.getNewUUID(), "Max Participants", Number(maxCurrentParticipants[0][0]) - (Number(maxCurrentParticipants[0][1] + Number(newParticipants))), 2];
}

result.object(ret);