topic Re: Time definition query in Collector and going offline in ArcGIS Collector Questions

Time definition query in Collector and going offline

PeterTimmers — Fri, 05 Dec 2014 05:23:53 GMT

A while back Russ pointed out to me that you can't use time definition queries in your map service if you want the data to go offline.

Is that still true? I know it's possible in arcgis mobile.

e.g. I want to only show the last 24 hours mapping on Collector. Our fire air observers need to be able have a relatively clear space for new mapping with fires changing over time.

Or are we better off using scheduled tasks to move data to new tables?

Re: Time definition query in Collector and going offline

GISSupport3 — Mon, 08 Dec 2014 00:06:24 GMT

Just tried one of our maps with with time based definition query and got the following:

Error executing tool.: ErrorMsg@SyncGPService:{"code":500,"description":"Failed to create replica."} Failed to execute (Create Feature Service Replica).

Could be due to anything mind you.

See what Russ has to say

Re: Time definition query in Collector and going offline

VHolubec — Mon, 16 Feb 2015 08:33:11 GMT

Dears,

it looks like the problem with query. AGS for replica creates FGDB. And if the query comes from SDE (MS SQL for example), you can have trouble with this query in replica and map package too. The query for replica cannot be compatibile with FGDB - for exmaple

my queyry is: convert(date,datum,102) = convert(date,GETDATE()-59,102)

It works for SDE, but I cannot create replica, and this query does not work in map package, because this query works only for database and not for FGDB.

As solution it looks the best way create some number column where you will have numbers - number of hours since. And to this column use Definition query - number of hours < 5 (for example). It should work.

Re: Time definition query in Collector and going offline

MarkPeacey2 — Wed, 19 Aug 2015 21:16:04 GMT

Thanks for this, it explains the problem I was having here Non standardized def query breaks Create Replica function . It would be nice if the queries compatible with FGDB could be expanded.

Re: Time definition query in Collector and going offline

PeterTimmers — Thu, 20 Aug 2015 22:52:13 GMT

Pardon my ignorance, but how would I construct a numeric field (like hours since) to only show the last 7 days features?

Could you have a scheduled action in the DB to recalculate all rows every hour... sounds onerous, especially if there is a lot of data.

Re: Time definition query in Collector and going offline

GISSupport3 — Tue, 19 Jan 2016 23:32:51 GMT

Will this be supported in the pending 10.4 release; ie can go offline with time based definition queries.

Thanks