Skip to content
Snippets Groups Projects
possibleItemsProcess.js 627 B
import("system.db");
import("system.result");
import("system.vars");
import("Attribute_lib");
import("Sql_lib");

var attributeId = vars.get("$field.AB_ATTRIBUTE_ID");
var attrType = AttributeHandler.begin(attributeId).getAttributeType();

if (attrType == $AttributeTypes.COMBO)
{
    var valueSql = SqlCondition.begin()
        .andPrepare("AB_ATTRIBUTE.ATTRIBUTE_PARENT_ID", attributeId)
        .andPrepare("AB_ATTRIBUTE.ATTRIBUTE_TYPE", $AttributeTypes.COMBOVALUE)
        .buildSql("select AB_ATTRIBUTEID, ATTRIBUTE_NAME from AB_ATTRIBUTE");
    var valueList = db.table(valueSql);
    
    result.object(valueList);
}