Newer
Older
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);
}