Incidents Query - Created On Between Two Times (Historical)

[jacobspacek]

I need help modifying this query.

Currently, this query will display all incidents created between 8AM and 4PM on 2024-10-10.

I need to modify this query to return all incidents created between 8AM and 4PM historically (for all dates)?

var gr = new GlideRecord('incident');
var count = 0;

// incidents created between 8AM & 4PM
gr.addEncodedQuery("sys_created_onBETWEENjavascript:gs.dateGenerate('2024-10-10','08:00:00')@javascript:gs.dateGenerate('2024-10-10','15:59:00')");

gr.query();
while (gr.next()) 
{
	gs.info(gr.getDisplayValue());
	count +=1;
}

gs.info(count);

Any help is greatly appreciated!

[Bert_c1]

you should post your code as text, if you want what you posted to be useful to others. So they can 'Copy-and-paste'.

[jacobspacek]

Yeah SNOW deff was messing with your colons!

Awesome this is working I think.

One question

gr.addEncodedQuery
(
	"sys_created_onDATEPART8 am hour@javascript:gs.datePart('hour','8','EE')^OR
	sys_created_onDATEPART9 am hour@javascript:gs.datePart('hour','9','EE')^OR
	sys_created_onDATEPART10 am hour@javascript:gs.datePart('hour','10','EE')^OR
	sys_created_onDATEPART11 am hour@javascript:gs.datePart('hour','11','EE')^
	ORsys_created_onDATEPARTNoon hour@javascript:gs.datePart('hour','12','EE')^
	ORsys_created_onDATEPART1 pm hour@javascript:gs.datePart('hour','13','EE')^
	ORsys_created_onDATEPART2 pm hour@javascript:gs.datePart('hour','14','EE')^
	ORsys_created_onDATEPART3 pm hour@javascript:gs.datePart('hour','15','EE')^
	ORsys_created_onDATEPART4 pm hour@javascript:gs.datePart('hour','16','EE')"
);

the line for "ORsys_created_onDATEPARTNoon"

what is the equivalent of the "Noon" portion for midnight?

Is it just 24?

[Justin Hatfield]

(remember to replace the :)

^ORsys_created_onDATEPARTMidnight hour@javascript:gs.datePart('hour','0','EE')

[jacobspacek]

Worked like a charm!

I wish there was a simpler syntax to accomplish this.

[jacobspacek]

Hey I thought this was working but unfortunately, I cant not get this script to filter for incident records between 8AM and 4PM.

		var sysIDs = [];
		var gr = new GlideRecord('incident');
		gr.addQuery('active', true);
		gr.addEncodedQuery("assignment_group.typeLIKE8c17c386c3c90614d327f19f05013175"); // Service Assurance
		gr.addEncodedQuery("sys_created_onDATEPART8 am hour@javascript:gs.datePart('hour','8','EE')^ORsys_created_onDATEPART9 am hour@javascript:gs.datePart('hour','9','EE')^ORsys_created_onDATEPART10 am hour@javascript:gs.datePart('hour','10','EE')^ORsys_created_onDATEPART11 am hour@javascript:gs.datePart('hour','11','EE')^ORsys_created_onDATEPARTNoon hour@javascript:gs.datePart('hour','12','EE')^ORsys_created_onDATEPART1 pm hour@javascript:gs.datePart('hour','13','EE')^ORsys_created_onDATEPART2 pm hour@javascript:gs.datePart('hour','14','EE')^ORsys_created_onDATEPART3 pm hour@javascript:gs.datePart('hour','15','EE')");
		gr.query();
		while (gr.next()) 
		{
			sysIDs.push(gr.getValue('sys_id'));
		}
		return sysIDs.toString();