valueProcess.js

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

if(vars.exists("$param.OfferHeader_param") && vars.get("$param.OfferHeader_param")) 
    result.string(vars.get("$param.OfferHeader_param"));

else if(vars.get("$this.value"))
    result.string(vars.get("$this.value"));

else if(vars.get("$sys.recordstate") == neon.OPERATINGSTATE_NEW)
    result.string("Gerne bieten wir Ihnen wie folgt an:"); //TODO: translate

if (vars.get("$field.ChoosenTEXHeader") != "")
{
    var binaryId = db.cell(SqlCondition.begin()
        .andPrepareVars("ASYS_BINARIES.ROW_ID", "$field.ChoosenTEXHeader")
        .buildSql("select ID from ASYS_BINARIES"), SqlUtils.getSystemAlias());
    result.string(util.decodeBase64String(db.getBinaryContent(binaryId, SqlUtils.getSystemAlias())));
}