Why is gr.update() duplicating the current record and not updating?

[Ulrich Matthew]

When i click on ok, the record I'm working with is being duplicated and not updated

function onCancel() {
    GlideDialogWindow.get().destroy();
    return false;
}

function onSubmit() {
    var reason = document.getElementById('termination_reason').value;
    var date = document.getElementById('termination_date').value;
    var sysId = g_form.getUniqueValue();
    /*g_form.setValue('u_reason', reason);
	g_form.setValue('u_termination', date);

	g_form.save();
*/

    var employees = new GlideRecord('u_itechag_employees');
    employees.addQuery('sys_id', sysId);
    employees.query();


    if (employees.next()) {
        employees.u_reason = reason;
        employees.u_termination = date;
        employees.update();
    }


    location.reload();

    return true;
}

[Mohith Devatte]

And also replace your glide ajax like below

var ga = new GlideAjax('terminate_employee');//this is the script include
ga.addParam("sysparm_name", "Terminate"); //this is the function within the script include
ga.addParam("sysparm_id", g_form.getUniqueValue());
ga.addParam('sysparm_reason',reason);
ga.addParam('sysparm_date',date);
ga.getXML(getResponse);

function getResponse(response) {
// do nothing
}

[Ulrich Matthew]

made both changes but the record was not updated yet 😞

[Mohith Devatte]

Put these logs below there two lines and check if logs are coming in logs table

Terminate:function()
{ 

gs.info('Record sys_id'+this.getParameter('sysparm_id'));

gs.info('My record reason'+this.getParameter('sysparm_reason'));

gs.info('My record date'+this.getParameter('sysparm_date'));

[Ulrich Matthew]

they are being captured 

[Mohith Devatte]

great! now can you put log inside this if loop like gs.info('inside the if loop');

and check if it is finding the record with sys_id

if (employees.next()) {