valueProcess.js

import("system.neon");
import("system.vars");
import("system.result");
import("system.text");
import("Sql_lib");

if(!vars.get("$this.value"))
{
    var sysSelection = vars.get("$sys.selection");
    var uid = vars.get("$field.UID");
    var id;
    if(vars.get("$sys.operatingstate") == neon.OPERATINGSTATE_EDIT )
    {
        if(sysSelection.length > 0)
        {
            var res;
            var value = vars.get("$field.CLASSIFICATION_PARENT_ID");
            if(value)
            {
                if(value.charAt(0) != ";" && value.charAt(value.length) != ";")
                    id = text.decodeMS(uid)[1];
                else
                {
                    decodedIdvalues = text.decodeMS(value);
                    if(decodedIdvalues[0].charAt(0) != ";" && decodedIdvalues[0].charAt(decodedIdvalues[0].length) != ";")
                        id = text.decodeMS(text.decodeMS(uid)[0])[1];
                }
            }
        }
    }
    else if(vars.get("$sys.operatingstate") == neon.OPERATINGSTATE_NEW)
        id = vars.get("$field.CLASSIFICATIONGROUP");
        
    var sorting = newSelect("CLASSIFICATIONGROUP.SORTING")
                                .from("CLASSIFICATIONGROUP")
                                .where("CLASSIFICATIONGROUP.CLASSIFICATIONGROUPID", id)
                                .cell();
    if(sorting)
        result.string(sorting);
    else
        result.string("1");
}