topic Query based on datetime field over geodatabase offline layer doesn't work in ArcGIS Enterprise Questions

Query based on datetime field over geodatabase offline layer doesn't work

JorgeAtanacio_Galindo — Wed, 25 Jan 2017 01:42:45 GMT

I've downloaded a local geodatabase to work offline in my Windows 8.1 Tablet, and I need to get features from a specific layer based on datetime field, I can get this with online layer in rest service through next line:

"REALDATE >= date '" + DateTime.Now.ToUniversalTime() + "' AND REALDATE <= date '" + DateTime.Now.AddDays(1).ToUniversalTime() +"' and works perfectly; but when I tried to execute this query on my local geodatabase layer, never return features, someone could explain why it is not working.

Thanks.

Re: Query based on datetime field over geodatabase offline layer doesn't work

JoshuaBixby — Wed, 25 Jan 2017 02:15:47 GMT

The GeoNet Help place is for help with GeoNet itself, not general help from the GeoNet community. You might want to move this to another place to increase visibility. For now, I will share with https://community.esri.com/community/gis?sr=search&searchId=e7ebcacc-1fb0-4d49-ab8b-b2f221111e1e&searchIndex=0‌ to get a few more pairs of eyes on it.

Seeing that you aren't using a RESTful query to access the data in the local geodatabase, how are you accessing the local/offline data. I can't really comment on the format of the query until I know more about how or what app/tool you are using to access the local/offline data.

Re: Query based on datetime field over geodatabase offline layer doesn't work

JorgeAtanacio_Galindo — Wed, 25 Jan 2017 02:28:01 GMT

Hello Joshua, thank you for your response, I'm developing a Windows Store App using ArcGIS Runtime SDK for .NET Ver. 10.2.7; I'm using services pattern to get my local geodatabase and coding in C# over Visual Studio 2015.

I have published my service in ArcGIS for Server 10.4.1, and layers are on SQL Server 2014.