Help With On Submit Script Check for existing Active Records

[Nic Omaha]

I have a record producer that is creating a record on a custom table inherited from task. On submit I would like to check if an existing ACTIVE record exists with the same order number. Currently I have the script working if ANY record exists but cant seem to figure out how to add in the Active query. Any help would be appreciated. Also a bonus would be if we could also prompt the record numbers found. 

function onSubmit() {
    //Type appropriate comment here, and begin script below
    var orderId = g_form.getValue('u_order_number');
    var gr = new GlideRecord('u_flooring_measures');
    gr.addQuery('u_order_number', orderId);
    gr.query();

    if (gr.next()) {
        alert("Sorry someone is already working on this!");
        return false;
    }
}

[Brian Lancaster]

You can use one of the following.

gr.addActiveQuery()

or

gr.addQuery('u_active', true); note that I'm just guessing the active field would have a u_ at the beginning.

[AshishKM · Accepted solution]

Hi @Nic Omaha ,

Add the condition for active status.

function onSubmit() {
    //Type appropriate comment here, and begin script below
    var orderId = g_form.getValue('u_order_number');
    var gr = new GlideRecord('u_flooring_measures');
     gr.addQuery('active', true) ;   // or gr.addActiveQuery();  custome table extends Task table then active should be there  
    gr.addQuery('u_order_number', orderId);
    gr.query();

    if (gr.next()) {
        alert("Sorry someone is already working on this!");
        return false;
    }
}

-Thanks,

AshishKMishra

[Nic Omaha]

Thank you so much! This worked perfectly I was really close! Any idea on how we might add what the record number found that matches in the alert? In a perfect world we would like to alert there's already something open and easily get them to that record. Not sure quite how to attack that but your script definitely solves most of my problems. Thanks again! 

[AshishKM]

If you review the script code the "orderId" which you are passing in "gr.addQuery()" is the match. So if want to add that order number in the alert message replace the aler() as below.

alert("Sorry someone is already working on this! "+gr.u_order_number);

let me know if this works for you or not.