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