nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Time definition query in Collector and going offline

PeterTimmers

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?

Find more posts tagged with

Accepted answers

VHolubec

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.

All comments

GISSupport3

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

Thanks

PeterTimmers

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.

MarkPeacey2

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.

VHolubec

Dears,

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.

GISSupport3

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

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.