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 ADDRESS.ADDRESSID in ('" + affectedIds.map(function (v){return db.quote(v);}).join("', '") + "')";
    //TODO: refactor this for incremental indexer (injections?)
}

sqlQuery = "select ADDRESS.ADDRESSID as uid" 
    + ', ADDRESS.ZIP as "ZIP.value"' 
    + ', ADDRESS.CITY as CITY' 
    + ', ADDRESS.COUNTRY' 
    + ', ADDRESS.ADDRESS' 
    + ', ADDRESS.BUILDINGNO'
    + " from ADDRESS"
    + (queryCondition || "") 
    + " order by ADDRESS.ADDRESSID ";

result.string(sqlQuery);