valueProcess.js

import("Sql_lib");
import("Entity_lib");
import("system.logging");
import("system.vars");
import("system.result");

//references needed for auto refresh:
"$field.PersAddresses.insertedRows";
"$field.PersAddresses.changedRows";
"$field.PersAddresses.deletedRows";

var res = "";
var country = vars.get("$field.STANDARD_COUNTRY");
var orgAddressId = newSelect("CONTACT.ADDRESS_ID").from("CONTACT")
                                                    .where("CONTACT.ORGANISATION_ID", vars.get("$field.ORGANISATION_ID"))
                                                    .and("CONTACT.PERSON_ID is null")
                                                    .cell();
                                                                    
var standardCountryOrg = newSelect("ADDRESS.COUNTRY").from("ADDRESS")
                                                             .where("ADDRESS.ADDRESSID", orgAddressId).cell();

if(country)
{
    res = country;
}
else if(standardCountryOrg)
{
    res = standardCountryOrg;
}
else
{
    var addressPersonRows = EntityConsumerRowsHelper.getCurrentConsumerRows("PersAddresses", ["COUNTRY"]);
    if(addressPersonRows.length > 0)
        res = addressPersonRows[0]["COUNTRY"];
}
result.string(res);