My IT department extracts crime data with a timestamp field. When I setup my query only the data appears in pick list.. Is the problem in the data extract format from SQL. Or the Web App Builder does not support a timestamp field? Some extract the timestamp does not appear at all. Works fine within ArcMap.
Solved! Go to Solution.
Do you know of any reason why the timestamp field would only produce a date with no time? Or why some of the extracts the timestamp field does not appear in WAB?
Chet Shuler, P.S. | Chief Engineering Technician / GIS
City of Middletown — Information Systems
1 Donham Plaza
Middletown, Ohio 45042-1932
(513) 425-7920 Office
(513) 425-7921 Fax
<https://www.facebook.com/cityofmiddletownoh> <http://www.twitter.com/CityMiddletown> <https://www.linkedin.com/company/city-of-middletown> <https://instagram.com/cityofmiddletownohio>
Do you know of any reason why the timestamp field would only produces a date with no time in the query builder? Or why some of the extracts the timestamp field does not appear at all in WAB? I'm thinking it may be the way they are extracting the data from a older database. They tried to create a view within SQL and separate the date and time. However the our police department wants to be able to query the timestamp field between for an example between 1/1/2016 22:00:00 hours and 1/2/2016 02:00:00 hours the next day. Has to be a format issues.
Sorry I had some typos in the previous post.. Wasn't expecting a quick reply.. Thanks..
The query widget does not support querying by a specific time from the UI. The code behind the scenes sets the time portion of the chosen date to cover the 24 hour period of that date. If you want to query a specific time of a specific date then that would involve customizing the widgets UI and code base to support that.