import("Sql_lib");
import("system.result");
import("system.vars");
import("system.db");

var contactId = "";

if(vars.get("$field.LEAD_PERSON"))
    contactId = newSelect("CONTACTID")
                    .from("CONTACT")
                    .whereIfSet("CONTACT.PERSON_ID", "$field.LEAD_PERSON")
                    .cell(true);
else
    contactId = newSelect("CONTACTID")
                    .from("CONTACT")
                    .whereIfSet("CONTACT.ORGANISATION_ID", "$field.LEAD_ORGANISATIONID")
                    .cell(true);
    
result.string(contactId);