valueProcess.js

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

if (vars.get("$this.value") == null)
{
    if(vars.exists("$param.OrderHeader_param") && vars.get("$param.OrderHeader_param")) 
        result.string(vars.get("$param.OrderHeader_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: translation

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