I have a requirement where i need to filter the contacts based on customer.
my two fields on the table are customer,contact
customer is refrenced to account table
and contact is refrence to customer_contact table.
i tried writing a script include but it is not fetching me the results:
var getContactCustomer = Class.create();
getContactCustomer.prototype = {
initialize: function() {
},
getContact : function()
{
var contact = new GlideRecord('customer_contact');
contact.addQuery('sys_id','account');
contact.query();
if(contact.next())
{
return "account"+"="+contact.customer.toString();
}
},
type: 'getContactCustomer'
};
i used the script include on the variable contact :javascript : new getContact().getContact()
