want to change end date(planned end date) field of change request via fix script

[nitin51]

want to change end date(planned end date) field of change request via fix script.

as from list view, there is a restriction with ACLS. 

tried below code, please help.

var g = new GlideRecord('change_request');

g.addEncodedQuery('number=CHG0000096');

g.query();

while(g.next()){

g.end_date = 2024-12-30;

g.setWorkflow(false);

g.autoSysFields(false);

g.update();

}

[OlaN]

Hi,

This isn't working because you are sending a Number into a field that expects a DateTime.

Also, on a side note, the field is a DateTime, but you are attempting to input a Date, so results might not be want you want, because if not set, the time will default to 00:00:00 (system time usually GMT).

Try this instead:

var changeRequestGR = new GlideRecord('change_request');
changeRequestGR.addEncodedQuery('number=CHG0000096');
changeRequestGR.query();
 
while(changeRequestGR.next()){
    var gdt = new GlideDateTime('2024-12-30');
    changeRequestGR.setValue('end_date', gdt.getValue());
    changeRequestGR.setWorkflow(false);
    changeRequestGR.autoSysFields(false);
    changeRequestGR.update();
}

[yaswanthi2]

Hi @nitin51 

var g = new GlideRecord('change_request');

g.addEncodedQuery('number=CHG0000096');

g.query();

while(g.next()){

g.end_date = '2024-12-30'; // put quotation mark '2024-12-30' like this or if you want with in time then put g.end_date= new GlideDateTime('2024-12-30')

g.setWorkflow(false);

g.autoSysFields(false);

g.update();

}

[Amit Gujarathi]

Hi @nitin51 ,
I trust you are doing great.
Please find the below code for the same.

var changeRequestNumber = 'CHG0000096'; // Change request number
var newEndDate = new GlideDateTime('2024-12-30'); // New end date

var gr = new GlideRecord('change_request');
gr.addQuery('number', changeRequestNumber);
gr.query();

if (gr.next()) {
    gr.setValue('end_date', newEndDate);
    gr.setWorkflow(false); // Disables business rules, workflows, etc.
    gr.autoSysFields(false); // Prevents updating system fields like Updated By, Updated On
    gr.update();
    gs.info('Change request ' + changeRequestNumber + ' updated with new end date.');
} else {
    gs.warn('Change request ' + changeRequestNumber + ' not found.');
}

[Dr Atul G- LNG]

Any reason to do this? @nitin51