query.js

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

var affectedIds;
if (vars.exists("$local.idvalue")) {
    affectedIds = vars.get("$local.idvalue");
}

result.string(db.translateStatement(SqlCondition.begin()
            .andIn("ADDRESS.ADDRESSID", affectedIds)
            .buildSql("select \n\
                        ADDRESS.ADDRESSID as \"_uid_\", \n\
                        ADDRESS.ADDRESSID, \n\
                        ADDRESS.ZIP as ZIP, \n\
                        ADDRESS.CITY as CITY, \n\
                        ADDRESS.COUNTRY, \n\
                        ADDRESS.ADDRESS, \n\
                        ADDRESS.BUILDINGNO from ADDRESS", "", "order by ADDRESS.ADDRESSID")));