How can I and query glide

tmiya · ‎07-19-2018

What I want is query by using from to.

For example,

var rec = new GlideRecord('incident');

rec.addQuery('sys_created_on','<',todate);
rec.addQuery('sys_created_on','>',fromdate);

in server script.

But it doesn't work well.

(fromdate and todate is GlideDateTime Object.)

Does anyone know how?

ScienceSoft · ‎07-19-2018

Hi tmiya,

The following script can be helpful:

var fromdate = new GlideDateTime('some start date');
var todate = new GlideDateTime('some end date');

var gr = new GlideRecord('incident');
gr.addQuery('sys_created_on', '>=', fromdate);
gr.addQuery('sys_created_on', '<=', todate);
gr.query();

View solution in original post

Allen Andreas · ‎07-20-2018

Glad you got it to work...

Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!