defining dates in array elements giving error

vass2 · ‎03-09-2018

Hi Friends ,

Below i am trying to fetch some changes and update those actual start and end dates using arrays.

But its giving the following error while using arrays. Not sure what is the exact code to write here. Can you please help me on this.

//var arrayUtil = new ArrayUtil();
var stDate = new Array[ {date: "19/02/2018 09:15:33"}, {date: "06/02/2018 18:47:12"}, {date: "30/11/2017 13:28:24"}, {date: "15/02/2018 23:36:37"}];
var edDate = new Array[ {date: "19/02/2018 09:28:32"}, {date: "07/02/2018 01:34:43"}, {date: "05/02/2018 08:11:44"}, {date: "15/02/2018 23:37:38"}];
var gr = new GlideRecord('change_request');
gr.addQuery('number','IN','CHG0030526,CHG0030951,CHG0031396,CHG0031848');

gr.query();

while (gr.next() ) {

//gs.print ('Change Number ' + gr.number);

}
gs.print('Total records ' + gr.getRowCount());

--------------------------------------------------------------------------

[0:00:00.006] Script completed in scope global: script

Evaluator: org.mozilla.javascript.EcmaError: undefined is not a function.
   Caused by error in script at line 2

      1: //var arrayUtil = new ArrayUtil();
==>   2: var stDate = new Array[ {date: "19/02/2018 09:15:33"}, {date: "06/02/2018 18:47:12"}, {date: "30/11/2017 13:28:24"},   {date: "15/02/2018 23:36:37"}];
      3: var edDate = new Array[ {date: "19/02/2018 09:28:32"}, {date: "07/02/2018 01:34:43"}, {date: "05/02/2018 08:11:44"},   {date: "15/02/2018 23:37:38"}];
      4: var gr = new GlideRecord('change_request');
      5: gr.addQuery('number','IN','CHG0030526,CHG0030951,CHG0031396,CHG0031848');

Shishir Srivast · ‎03-11-2018

Array value should be as string, in array you are not having the values in quotes. either you can have the array defines like below

var stDate = [
	["date: 19/02/2018 09:15:33"], 
	["date: 06/02/2018 18:47:12"], 
	["date: 30/11/2017 13:28:24"], 
	["date: 15/02/2018 23:36:37"]
];

var edDate = [
	["date: 19/02/2018 09:28:32"], 
	["date: 07/02/2018 01:34:43"], 
	["date: 05/02/2018 08:11:44"], 
	["date: 15/02/2018 23:37:38"]
];

var i= 0; // declare the i as var
var gr = new GlideRecord('change_request');
gr.addQuery('number','IN','CHG0030526,CHG0030951,CHG0031396,CHG0031848');
gr.query();
gs.print('Total records ' + gr.getRowCount());
while(gr.next()) {
	gs.print ('Change Number : ' + gr.number + 'Actual Start Date : '+ stDate[i] + 'Actual End Date : ' + edDate[i]);
	i++;
}

OR like below,

var stDate = [
	["date", "19/02/2018 09:15:33"], 
	["date", "06/02/2018 18:47:12"], 
	["date", "30/11/2017 13:28:24"], 
	["date", "15/02/2018 23:36:37"]
];

var edDate = [
	["date", "19/02/2018 09:28:32"], 
	["date", "07/02/2018 01:34:43"], 
	["date", "05/02/2018 08:11:44"], 
	["date", "15/02/2018 23:37:38"]
];

var i= 0;
var gr = new GlideRecord('change_request');
gr.addQuery('number','IN','CHG0030526,CHG0030951,CHG0031396,CHG0031848');
gr.query();
gs.print('Total records ' + gr.getRowCount());
while(gr.next()) {
	gs.print ('Change Number : ' + gr.number + ',   Actual Start Date : '+ stDate[i][1] + ',   Actual End Date : ' + edDate[i][1]);
	i++;
}

Another way of using is JSON, there also you need to keep the date keyword as string: you can get the JOSN Array info here: https://www.w3schools.com/js/js_json_arrays.asp

https://www.w3schools.com/js/js_json_parse.asp

View solution in original post

vass2 · ‎03-12-2018

Thank you very much Tushar, that helped a lot

Regards,
Srinivas