Skip to content
Snippets Groups Projects
valueProcess.js 841 B
Newer Older
S.Listl's avatar
S.Listl committed
import("system.result");
import("system.db");
import("Sql_lib");
import("system.vars");

var objectType = vars.exists("$param.ObjectType_param") && vars.get("$param.ObjectType_param");
var rowId = vars.exists("$param.ObjectRowId_param") && vars.get("$param.ObjectRowId_param");
if (rowId)
{
    var condition = SqlCondition.begin()
        .andPrepare("AB_ATTRIBUTERELATION.OBJECT_ROWID", rowId);
    if (objectType)
        condition.andPrepare("AB_ATTRIBUTERELATION.OBJECT_TYPE", objectType);
    var relationCounts = db.table(condition.buildSql(
        "select AB_ATTRIBUTE_ID, count(AB_ATTRIBUTE_ID) from AB_ATTRIBUTERELATION",
        "1=2",
        "group by AB_ATTRIBUTE_ID"
    ));
    var countObj = {};
    relationCounts.forEach(function (row)
    {
        this[row[0]] = row[1];
    }, countObj);
    result.object(countObj);
}