valueProcess.js

import("system.logging");
import("KeywordRegistry_basic");
import("Contact_lib");
import("system.result");
import("system.vars");
import("Sql_lib");

var orgContactId = vars.get("$field.ORGANISATION_CONTACT_ID");
var contactIdArray = newSelect("CONTACT.CONTACTID")
                                .from("CONTACT")
                                .where("CONTACT.ORGANISATION_ID", ContactUtils.getPersOrgIds(orgContactId)[2], SqlBuilder.EQUAL())
                                .and("CONTACT.CONTACTID", orgContactId, SqlBuilder.NOT_EQUAL())
                                .and("CONTACT.STATUS", $KeywordRegistry.contactStatus$inactive(), SqlBuilder.NOT_EQUAL())
                                .arrayColumn();
                                
result.object(contactIdArray)