Good Morning,
I have been attempting to piece together a client script that helps me pull data from one table and display it as an alert on the incident form. The business reason behind this is that our managers need to alert the technicians about problems in locations without relying on the technician to go look at a note somewhere in the company’s information.
First a little reference as to the structure of our instance:
The Incident Form
The company profile for Willacy County, TX with an custom alert made by a manager.
This alert is stored in our u_customer_alerts table.
I am open to any alternative suggestions but what I would like to do is when the Company/Facility field changes on the incident form I would like the script to search the u_customer_alerts table for a matching name (in this case Willacy County, TX) then find an alert where the alert category is Incident Alert and finally get the note on the alert and return it to the incident form via an alert(u_note); method so it pops up for the technician.
Here is the client script I have to do this so far but it’s just not returning any results.
Type: ON CHANGE
Field Name: Company / Client
function onChange(control, oldValue, newValue, isLoading, isTemplate) {
if (isLoading || newValue === '')
{
return;
}
//The only way I could figure out how to search was to use this line plus the function
var comp = g_form.getReference('company', getCompany);
function getCompany(comp)
{
//Look at the customer alerts
var findAlerts = new GlideRecord('u_customer_alerts');
//Limit by where the name is the same as the one in the company field
findAlerts.addQuery('u_client_profile', comp.name);
//Limit by ones with type Incident Alert
findAlerts.addQuery('u_alert_category', 'Incident Alert');
//Run it
findAlerts.query();
//Return the alert
alert('ALERT: ' + findAlerts.getDisplayValue(u_notes));
}So there we have it, I am at a loss because nothing comes back…any ideas how I can fix this?
