how to retrieve data from two and three days ago?

rjp · ‎06-12-2020

Hi Gurus,

Is it possible to retrieve data that has an updated date equal to Yesterday AND two days ago AND three days ago.

I see there are built-in options for today, yesterday, last 7 days etc, but that goes back to far. I just need for the past three days.

Let me know if you think this is possible.

Thanks,

Rob

Harsh Vardhan · ‎06-14-2020

try now

usrCount = new GlideRecord("sn_imt_quarantine_unanswered_health_status_user");
usrCount.addEncodedQuery('u_unanswered_dateRELATIVELT@dayofweek@ago@3^u_unanswered_dateRELATIVEGT@dayofweek@ago@4');
usrCount.query();

var userArray = [];
while(usrCount.next()){

usrCount2 = new GlideRecord("sn_imt_quarantine_unanswered_health_status_user");
usrCount2.addEncodedQuery('u_unanswered_dateRELATIVELT@dayofweek@ago@2^u_unanswered_dateRELATIVEGT@dayofweek@ago@3^u_person=usrCount.u_person.name');

usrCount2.query();

while(usrCount2.next()){

gs.log('here1');
gs.log(usrCount2.u_person.name);
userArray.push(usrCount.sys_id.toString());
}

}

View solution in original post

Sravan21 · ‎06-12-2020

Sure, let me know if it doesn't work as expected. Thank you.

Regards,

Sravan.

rjp · ‎06-12-2020

Hi Sravan,

I believe I've followed all necessary steps:

Here's my script include:

This returns one value, which is: Zachary Testo

Here's my report filter:

However my results are:

Please let me know if you see anything that may be wrong.

Thanks,

RJP

rjp · ‎06-12-2020

Hi Sravan,

Actually it appears as though the report does not recognize the script include. Notice that the Person Name = NULL however the javascript is specified in the conditions below.

Very strange...

Sravan21 · ‎06-12-2020

Hi rjp,

Try adding the below under Person column search and see whether you are getting the results.

=javascript:get3DaysAgoData()

Regards,

Sravan

rjp · ‎06-12-2020

That just seems to default to NULL..and it brings back only names with NULL values.

I'm thinking it has to do with the definition of the script include, maybe something is wrong with it....