Create button to update current records

Priti18 · ‎10-30-2022

I want to update current records in cmdb_ci table but when user clicks on the UI action it should open the comment box and when user clicks on ok it should update data along with that comment in short description.

can anyone help me with this requirement, that would be really helpful.

thanks!!

kamlesh kjmar · ‎11-01-2022

Please try the below script:

function UpdateData() {


    var answer = confirm('Do you want to update this record');

    if (answer) {

        gsftSubmit(null, g_form.getFormElement(), 'function_name');
    }
}

if (typeof window == 'undefined')

    updateValues();


function updateValues() {

    current.setValue("state", 7);
    current.update();
    var childInc = new GlideRecord("incident");
    childInc.addQuery("parent_incident", current.getUniqueValue());
    childInc.query();
    while (childInc.next()) {
        childInc.state = "7";
        childInc.comments = "Your comments here";
        childInc.update();
    }
    action.setRedirectURL(current);
}

I hope this help.

Please mark this helpful if this helps and Accept the solution if this solves your issue.

Regards,

Kamlesh

View solution in original post

Priti18 · ‎11-01-2022

function updateData() {

alert('code is running till here');

current.setValue("state", 7); // this is not updating
current.update();
action.setRedirectURL(current);

}

even this is not working it simply refreshes the page

kamlesh kjmar · ‎11-01-2022

Comment alert() line it's a client side code, won't work if written outside client function.

Regards,

Kamlesh

Priti18 · ‎11-01-2022

tried

i even put value in quotes and without quotes but everytime it just refreshes the page

i dont even see any error in browser

can you run this code in your instance and guide me

since its just a state field which i need to update through button

kamlesh kjmar · ‎11-01-2022

Please share the final script that you tried executing

Priti18 · ‎11-01-2022

function UpdateData() {

var answer = confirm('Do you want to update this record');

if (answer) {

gsftSubmit(null, g_form.getFormElement(), 'function_name');
}

if (typeof window == 'undefined')

updateValues();

function updateValues() {

current.setValue("state", 7);
current.update();
action.setRedirectURL(current);

}