dropDownProcess.js

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

var contactId = vars.get("$field.CONTACT_ID");
if (contactId)
{
    var addresses = newSelect("ADDR, ADDR")
                .from("COMMUNICATION")
                .where("COMMUNICATION.CONTACT_ID", contactId)
                .and("COMMUNICATION.MEDIUM_ID", CommUtil.getMediumIdsByCategory("EMAIL"), SqlBuilder.IN())
                .table()
        
    //include the currently set email address
    var currentAddress = vars.get("$field.EMAIL_ADDRESS");
    if (currentAddress && !addresses.some(function (row) {return row[0] == currentAddress;}))
    {
        addresses.push([currentAddress, currentAddress]);
    }   
    
    result.object(addresses);
}