search

conterra / mapapps-query-builder

The Query Builder Bundle allows you to create your own Query Tools, that perform custom queries to a store.
https://demos.conterra.de/mapapps/resources/apps/downloads_query_builder/index.html
Apache License 2.0
7 stars 6 forks source link

Date query on Oracle-based AGS services crashes #1

Closed alsFC closed 8 years ago

alsFC commented 9 years ago

When specifying a query using a date-field (type 'Date' in Oracle) on an Oracle-based AGS map service (AGS 10.3.1) the map server query crashes with the following error in AGS log:

Geodatabase error: Underlying DBMS error [ORA-01861: Literal stimmt nicht mit Formatzeichenfolge überein]

matthiasstein commented 9 years ago

Can you provide me the service url to investigate this issue?

alsFC commented 9 years ago

http://***/arcgis/rest/services/GeoWorld_WM/net_events/MapServer/1

Field: BEGIN_DATETIME

matthiasstein commented 9 years ago

At this time the Complex Query does not support native date queries. The query must be "where=zeitpunkt <= timestamp '2015-10-05'" but the query builder uses "where=zeitpunkt <= '2015-10-05'". It seems that not every underlying database supports this.

alsFC commented 9 years ago

OK, I think it would be a good idea to list the fully supported DBMS.. or to list known issues of query-builder with DBMS supported by ArcGIS for Server. Unfortunately Oracle is one of the most important I guess.. At least the error handling with map.apps could be improved because no message appears in the web application when AGS answers on failed queries.

matthiasstein commented 8 years ago

Fixed in https://github.com/conterra/mapapps-query-builder/releases/tag/v3.1.7 and map.apps 3.4.0.