valueProcess.js

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

if (!vars.get("$this.value"))
{
    var scoreType = vars.get("$param.Scoretype_param");

    result.string(db.cell(
            SqlCondition.begin()
                        .andPrepare("CLASSIFICATIONTYPE.SCORETYPE", scoreType, "# <> ?")
                        .and("CLASSIFICATIONTYPE.CLASSIFICATIONNUMBER = " + db.translateStatement(SqlCondition.begin()
                                                        .andPrepare("CLASSIFICATIONTYPE.SCORETYPE", scoreType, "# = ?")
                                                        .buildSql("(select CLASSIFICATIONNUMBER from CLASSIFICATIONTYPE", "1=2", ")")))
                        .buildSql("select 100.0 - sum(maxScore) from ( \n\
                                    select max(SCORE) maxScore from CLASSIFICATIONTYPE \n\
                                    join CLASSIFICATIONSCORE on CLASSIFICATIONSCORE.scoretype = CLASSIFICATIONTYPE.scoretype", "1=2", "group by CLASSIFICATIONTYPE.scoretype) maxScores")))
}