query.js

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

var sqlQuery, queryCondition, affectedIds;

if (vars.exists("$local.idvalue")) {
    affectedIds = vars.get("$local.idvalue");
    queryCondition = " where COMMUNICATION.COMMUNICATIONID in ('" + affectedIds.map(function (v){return db.quote(v);}).join("', '") + "')";
    //TODO: refactor this for incremental indexer (injections?)
}

sqlQuery = "select COMMUNICATION.COMMUNICATIONID, COMMUNICATION.ADDR from COMMUNICATION "
 + (queryCondition || "") 
 + " order by COMMUNICATION.COMMUNICATIONID ";

result.string(sqlQuery);