/**
* @description the saved search for fetching the customer based on the Email Id
* @param EMAIL_ID - the email id
* @param PHONE - the phone number
* @returns {*[]|Object[]}
*/
fetchCustomerByEmailId(EMAIL_ID) {
log.debug('EMAIL_ID==', EMAIL_ID);
let customerRecordID
let filterArray = []
if (jjUtil.checkForParameter(EMAIL_ID)) {
filterArray.push(["email", "is", EMAIL_ID.toString().trim()])
}
let customerSearchObj = search.create({
type: "customer",
filters:
[
["stage", "anyof", "CUSTOMER"],
"AND",
["isinactive", "is", "F"],
"AND"
].concat(filterArray),
columns:
[
search.createColumn({name: "internalid", label: "InternalID"}),
search.createColumn({
name: "entityid",
sort: search.Sort.ASC,
label: "Name"
}),
search.createColumn({name: "email", label: "Email"}),
search.createColumn({name: "phone", label: "Phone"}),
search.createColumn({name: "externalid", label: "ExternalID"})
]
});
let searchResultCount = customerSearchObj.runPaged().count;
customerSearchObj.run().each(function (result) {
customerRecordID = result.getValue({
name: "internalid", label: "InternalID"
})
//return true;
});
return customerRecordID;
}