Querying Incident table for date range

[monicanegi]

Hi ,

I am trying to fetch closed records from Incident table using below request-

I have two closed records with closed_at date as

2017-04-12 19:13:11

2017-05-25 09:29:01

1.Trying to fetch records with closed_at date > '2017-04-12 19:13:10', so i was expecting that it should fetch '2017-04-12 19:13:11'record as well, but it didn't fetch that record.

I had tried with '2017-04-12 19:00:00' as well but it didn't work either.

https://dev34617.service-now.com/api/now/table/incident?sysparm_query=closed_at%3Ejavascript%3Ags.da...

Although >'2017-04-12 00:00:00' does fetch '2017-04-12 19:13:11'.

2. Also trying with >= '2017-04-12 19:13:11', didn't work.

https://dev34617.service-now.com/api/now/table/incident?sysparm_query=closed_at%3E=javascript%3Ags.d...

3.Whereas fetching records < '2017-04-12 19:13:12' , fetches '2017-04-12 19:13:11' record .

https://dev34617.service-now.com/api/now/table/incident?sysparm_query=closed_at%3Cjavascript%3Ags.da...

Also with <='2017-04-12 19:13:11', it fetches the '2017-04-12 19:13:11' record

https://dev34617.service-now.com/api/now/table/incident?sysparm_query=closed_at%3C=javascript%3Ags.d...

4.While trying to fetch data within a date range (startdate as '2017-04-12 19:13:11' and enddate as '2017-05-25 09:29:01'), it fetches '2017-05-25 09:29:01' record but not '2017-04-12 19:13:11'

https://dev34617.service-now.com/api/now/table/incident?sysparm_query=closed_atBETWEENjavascript%3Ag...

So it seems that > and >= are not working as expected. Please help me in resolving this issue and let me know how to use > and >= in my request.

Thanks,

Monica

[sarfraz3]

Well the best way to do this would be... go to incident table add filter condition according to your requirement,.... run it.... then right click on the query and copy query.... you can apparently see the differences of the assignment operator and how it works....

note: please hit helpful/correct depending upon the impact

thanks

[monicanegi]

Hi,

I tried filtering on table , by adding filters as you have suggested but it doesn't fetch the desired output .

i had tried with closed 'at or after' '2017-04-12 19:00:00' but it didn't fetch record closed at '2017-04-12 19:13:11'

Thanks,

Monica

[Shishir Srivast]

Are you trying scripting??

Is getting report in this way is not working for you?

[monicanegi]

Hi Shihir,

Thanks for your reply.

But it didn't work.I tried filtering on table , by adding filters as you have suggested but it doesn't fetch the desired output .

i had tried with closed 'at or after' '2017-04-12 19:00:00' but it didn't fetch record closed at '2017-04-12 19:13:11'.

It seems at or after is not working as expected.Whereas 'at or before' works perfectly fine.

Thanks,

Monica