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!

[Justin Hatfield]

I don't know if this is the best way to do it, but you should be able to accomplish with this:

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')^ORsys_created_onDATEPART4 pm hour@javascript:gs.datePart('hour','16','EE')");

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')^ORsys_created_onDATEPART4 pm hour@javascript:gs.datePart('hour','16','EE')

[jacobspacek]

I tried adding the first encoded query into my example and it returns an error,

gr.addEncodedQuery("sys_created_onDATEPART8 am hour@javascript:gs.datePart('hour','8','EE')")

Script execution error: Script Identifier: unknown, Error Description: "javascript" is not defined., Script ES Level: 0

[Justin Hatfield]

I think the forum is escaping the colon(:) characters with ":". 

You can also type your instance in the following url and get the query from there.

https://[YOUR-INSTANCE].service-now.com/incident_list.do?sysparm_query=sys_created_onDATEPART8%20am%...

[Justin Hatfield]

Yea it doesn't like the colons. I added a text file with the code in it.