Something went wrong on our end
-
Johannes Hörmann authoredJohannes Hörmann authored
valueProcess.js 498 B
import("system.result");
import("system.db");
import("system.vars");
import("Sql_lib");
var orgId = vars.get("$field.ORGANISATION_ID");
if (orgId)
{
var orgContactId = db.cell(SqlCondition.begin()
.andPrepare("CONTACT.ORGANISATION_ID", orgId)
.and("CONTACT.PERSON_ID is null")
.buildSql("select CONTACT.CONTACTID from CONTACT"));
result.string(orgContactId);
}