Hi I'm trying to set up a date query using the Query widget in a Web AppBuilder app but the query doesn't return any results...can't figure out why. I get a message saying 'query failed!' and 'number of features found: 0', when there should definitely be some results returned. So far I've checked/ tried a few things: * The layer I'm using has time enabled * Filtering by date works fine within the web map * When setting the query up within the Query widget it recognises that the field I'm using is in Date format because it lets me set the default to search between two dates * When I look at the attribute table in the app it sorts the date field correctly Any suggestions for other things I can try? Thanks for your help!

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; } } }

ArcGIS Online - using the Query widget for Date queries

Cormaclacey

I'm trying to set up a date query using the Query widget in a Web AppBuilder app but the query doesn't return any results...can't figure out why. I get a message saying 'query failed!' and 'number of features found: 0', when there should definitely be some results returned.

So far I've checked/ tried a few things:

The layer I'm using has time enabled
Filtering by date works fine within the web map
When setting the query up within the Query widget it recognises that the field I'm using is in Date format because it lets me set the default to search between two dates
When I look at the attribute table in the app it sorts the date field correctly

Any suggestions for other things I can try?

Thanks for your help!

Encuentra más publicaciones etiquetadas con

Accepted answers

RobertScheitlin__GISP

Cormac,

You are running into an issue with the query widgets SQL statement being formed using 'timestamp' when it should not be. I have seen others report this issue and it seem to normally happen when people are using a featureLayer from AGOL for their query. This is some thing you need to call esri tech support about to make sure there is already a bug logged for this.

This is the query that the query widget sends:

http://services.arcgis.com/tnTLtmrGqbVBqigz/arcgis/rest/services/AGOL_Date_Test_WGS84.gdb/FeatureServer/0/query?f=json&returnIdsOnly=true&where=IncidentDate%20%3E%20timestamp%20%272012-11-01%2023%3A59%3A59%27&returnGeometry=false&spatialRel=esriSpatialRelIntersects&outSR=102100

this is what it should be sending:

http://services.arcgis.com/tnTLtmrGqbVBqigz/arcgis/rest/services/AGOL_Date_Test_WGS84.gdb/FeatureServer/0/query?f=json&returnIdsOnly=true&where=IncidentDate%20%3E%20%20%272012-11-01%2023%3A59%3A59%27&returnGeometry=false&spatialRel=esriSpatialRelIntersects&outSR=102100

All comments

LisaTurner

Hey Cormac,

You might want to move this question into Web AppBuilder for ArcGIS so it is seen by the widget group.

RobertScheitlin__GISP

Cormac,

I have setup the query widget using time enabled layers and not had any issue.

Is there any other details on your setup you can provide?
Is your service public where I can test it?
What is the underlying database that the service comes from (oracle, sql server, etc)?
Is the service coming from AGOL web map or a ArcGIS Server service?

Cormaclacey

Lisa, Robert - thanks for your replies.

I can't make the service public unfortunately because the data is sensitive, but I'm going to try with a different 'test' layer tomorrow and see if I get the same problems.

The only other information I can give is that the service is hosted on AGOL using Feature Layers that have been uploaded to the AGOL server - so there is nothing held outside of AGOL.

Any other suggestions on what I can try would be appreciated, I'll try posting on the Web AppBuilder forum tomorrow if I'm not having any more luck.

Thanks again

Cormaclacey

I've now tried with a test file and am getting the same error message...must be something in the way I've set up the query?

I've made the test app public - link below - if you are able to have a quick look and see if you can spot what the problem is I'd really appreciate it.

ArcGIS Web Application

Thanks again

RobertScheitlin__GISP

Cormac,

This is the query that the query widget sends:

this is what it should be sending:

http://services.arcgis.com/tnTLtmrGqbVBqigz/arcgis/rest/services/AGOL_Date_Test_WGS84.gdb/FeatureServer/0/query?f=json&returnIdsOnly=true&where=IncidentDate%20%3E%20%20%272012-11-01%2023%3A59%3A59%27&returnGeometry=false&spatialRel=esriSpatialRelIntersects&outSR=102100

RobertScheitlin__GISP

Here is another thread showing the same issue:

Re: How do you get a date query to work?

Cormaclacey

Robert - thanks for your help with this, I've reported the issue as a bug so hopefully someone at ESRI will have a look at it. In the meantime I'll set up a dummy date field using integers so users can still search by 'date'.

thanks again

SubuSwaminathan1

Can you provide the bug number? I would like to follow the bug and push up its priority with esri?

Thank you,

Subu

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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