add days for comparison to custom field

[MaharshiC]

Hi,

I was writing a scheduled script but was stuck at one point. In the below script "planned duration" variable is basically the number of the days that needs to be added. So now we have 2 scenarios -- 1)add the planned duration days to sys created on 2)add the planned duration to the validation field .. Then we need to find the max/later of the 2 dates after adding and check if today's date is equal to or greater than that max date then we need to close the task

var now = new GlideDateTime();
var created ='';
var planned_duration='';
var validation ='';
var sumofcreatedandplanned='';
var task = new GlideRecord('x_iem_tqa_work_order_task');
task.addEncodedQuery("stateIN1,2^task_type=task_for_site_acceptance");
task.query();
while(task.next())
{
	var order = task.associated_work_order_number;
	var workflowassign = task.associated_work_order_number.assocaited_work_request_number.workflow;
	created=task.sys_created_on.getGlideObject();
	validation = task.associated_work_order_number.tc_validation_end_by_planned;
	var workflow= new GlideRecord('x_iem_tqa_workflow_assignment');
	workflow.addQuery('sys_id',workflowassign);
	workflow.addEncodedQuery("planned_site_acceptance_duration_for_auto_closureISNOTEMPTY");
	workflow.query();
	if(workflow.next())
	{
      planned_duration=workflow.planned_site_acceptance_duration_for_auto_closure;
	  

	}
}

[Ankur Bawiskar]

@MaharshiC 

you are running the script in scoped app?

till which line it's working fine?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[MaharshiC]

Yes in scoped app. It ran till this.

var now = new GlideDateTime();
var created = '';
var planned_duration = '';
var validation = '';
var sumofcreatedandplanned = '';
gs.info('test7'+now);
var task = new GlideRecord('x_iem_tqa_work_order_task');
task.addEncodedQuery("stateIN1,2^task_type=task_for_site_acceptance");
task.query();
while (task.next()) {
	gs.info('test6'+task.sys_id);
    var order = task.associated_work_order_number;
    var workflowassign = task.associated_work_order_number.assocaited_work_request_number.workflow;
    created = task.sys_created_on;
    validation = task.associated_work_order_number.tc_validation_end_by_planned;
    var workflow = new GlideRecord('x_iem_tqa_workflow_assignment');
    workflow.addQuery('sys_id', workflowassign);
    workflow.addEncodedQuery("planned_site_acceptance_duration_for_auto_closureISNOTEMPTY");
    workflow.query();
    if (workflow.next()) {
		gs.info('test4'+task.sys_id);
        planned_duration = workflow.planned_site_acceptance_duration_for_auto_closure;
        // Add planned_duration days to both dates
		gs.info('test15'+task.sys_id+planned_duration);
        var createdPlus = new GlideDateTime(created);
		gs.info('test25'+createdPlus);

  After this it stopped at - createdPlus.addDaysUTC(planned_duration);

[Ankur Bawiskar]

@MaharshiC 

what value are you passing to that addDaysUTC()?

It should be an integer and not duration type

If my response helped please mark it correct and close the thread so that it benefits future readers.

[MaharshiC]

@Ankur Bawiskar ,

Yes i am passing integer field only

[Ankur Bawiskar]

@MaharshiC 

can you share the complete code again here along with the logs you added and till where it worked

If my response helped please mark it correct and close the thread so that it benefits future readers.