Ask Your Question
0

NEREN Active Agents by Update date range

asked 2017-04-18 10:16:16 -0500

Having trouble getting results for ActiveAgents using U_UpdateDate in search query while U_user_is_active works fine.

Using "((U_UpdateDate={$datewalkstart}T00:00:00+),(U_UpdateDate={$thenewdate}T23:59:59-))" where $datewalkstart is the start date and $thenewdate is the end date does not return anything.

Any help appreciated. Thanks.

edit retag flag offensive close merge delete

Comments

Is this: {$datewalkstart} a macro substitution you are doing on your side? Also the U_UpdateDate is in UTC.

bwolven gravatar imagebwolven ( 2017-04-18 11:07:04 -0500 )edit

Yes this is PHP - the same date variables work fine for all other tables - just ActiveAgent returns no results when using dates.

edgewrx gravatar imageedgewrx ( 2017-04-18 11:19:39 -0500 )edit

What is your account name? NO Passwords please.

bwolven gravatar imagebwolven ( 2017-04-18 11:32:03 -0500 )edit

username = edc61212

edgewrx gravatar imageedgewrx ( 2017-04-18 12:05:42 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted
0

answered 2017-04-18 14:02:35 -0500

In our logs, I see 117 ActiveAgent search requests with the same date range query:

((U_UpdateDate=2016-10-01T00:00:00+),(U_UpdateDate=2016-10-02T23:59:59-))

There were not any active agents updated with that 2 day range.

If I use a query like: (U_UpdateDate=2016-10-31T23:59:59-)) I show 7 agents.

edit flag offensive delete link more

Comments

my bad - was not handling empty results which caused failure on my end - have updated and successfully run. thank you

edgewrx gravatar imageedgewrx ( 2017-04-18 14:41:07 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-04-18 10:16:16 -0500

Seen: 23 times

Last updated: Apr 18 '17