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 in offline replica

JoeHershman

I see in the offline replica time is stored as a double. But I cannot figure out how this number is determined. I would have assumed it was unix time, but it is not.

Follow-up to that is how could one query a replica using a date. I want something like:

date component of datefield is April 14 2020.

Right now the only thing I can see if to return all the rows and filter, obviously not the approach I would like to take.

Thanks

-Joe

Vind meer berichten getagd met

Accepted answers

All comments

JoeHershman

A year in a half later, still have never figured out a way to query a date field using Runtime API

JoeHershman

What I want to do is run a query on the created date field. In our specific case we want to know if any records with a specific attribute have been created that day. Something like...

"Where CONTRACTOR = '{name}' AND CREATED_DATE = '04/14/2020'" I believe in a feature service I could do something like:

"Where CONTRACTOR = '{name}' and CREATED_DATE = DATE '04/14/2020'"

According to:

Querying Feature Services: Date-Time Queries

But don't seem to be able to get something like this working with a replica (and I have not tested this against a feature service to know if it would really work)

Thanks

-Joe

SomeGISGuy

...btw an informed guess is that it's likely a unix epoch of sorts.

SomeGISGuy

The database schema is afaik not documented, and subject to change at any time.

Are we missing an API you need, so you don't have to do that? If so, could you describe the scenario/user-story so we can add something to our backlog.

JoeHershman

I'm just looking at the database to see how it is stored. My goal is to make a query like I described. So my real question is about doing that. In trying to set that up I looked at the database to see that it is stored within the replica as a double. Thinking if I could figure out how that is derived I may be able to do the query I would like. Right now I am stuck with returning all the records and then checking dates.

SomeGISGuy

Which API are you seeing that we return a double instead of a date/time?

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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