dropDownProcess.js

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

var contactId = vars.get("$field.CONTACT_ID");

if (contactId)
{
    var  emailAddresses = new SqlBuilder().selectDistinct(["COMMUNICATION.ADDR","COMMUNICATION.ADDR"])
                         .from("COMMUNICATION")
                         .where("COMMUNICATION.OBJECT_ROWID",contactId)
                         .and("COMMUNICATION.OBJECT_TYPE", CommUtil.defaultObjectType())
                         .and("COMMUNICATION.MEDIUM_ID",CommUtil.getMediumIdsByCategory("EMAIL"),SqlBuilder.IN())
                         .table();
    result.object(emailAddresses);
}
else
{
    result.object([])
}