I'm developing a Web App for Collisions in Tulsa.
I built the MXD. It uses a Query Layer that pulls from some Oracle DB's.
I Shared the MXD as a REST Service.
I built an AGOL map using that REST Service.
I built a WAB App using that AGOL Map.
I added in the eSearch widget ( the one published on 23MAY ).
( thanks to creator Robert Scheitlin, GISP )
Configured it with my REST Service.
I'm getting nothing...
There is the link to the sandbox version of it.
I spent more than a few hours yesterday trying to figure it out. I'm at a loss. About to go back to the early version of the eSearch.
Solved! Go to Solution.
Brian,
There seems to be some issue with your map service when it comes to that particular date field. Here is what I am seeing:
This query using your map service REST endpoint works fine (returns 24 records)
INCIDENT_START_DATE BETWEEN timestamp '5/13/2016 00:00:00' AND timestamp '5/13/2016 23:59:59'
This one using the date date returns no results.
TPD_COLLISION_DATEBEGIN BETWEEN timestamp '5/13/2016 00:00:00' AND timestamp '5/13/2016 23:59:59'
Actually I can not get any TPD_COLLISION_DATEBEGIN query to work.
Brian,
I get data when I select by shape.
This is my map for Traffic accidents for my city. ( I cannot share webmap because the map is private)
But here is a screen shot. The user can filter by everything but day all at once.
*pinching the bridge of my nose*
Ok... I'm getting something back from there as well. So search by shape works... but nothing in regular searching?!
So confused... I think I'm MORE confused now than I was before... lol
Brian,
I think you are doing your widget set up wrong. I go it to work using your data.
What does your widget search layer look like?
This is WAB 2.0
Technically now I get double eSearch options when trying to re-add the widget...
I feel like I'm falling in the rabbit hole...
One option is to delete them both, re-import the widget after a fresh download and then start a new project.
That's the thing. In the actual FOLDERS in Windows Explorer, there is only one... But when I go to add a widget... there are two.
That is strange.
I would delete the one folder and re-add download it.
Brian,
There seems to be some issue with your map service when it comes to that particular date field. Here is what I am seeing:
This query using your map service REST endpoint works fine (returns 24 records)
INCIDENT_START_DATE BETWEEN timestamp '5/13/2016 00:00:00' AND timestamp '5/13/2016 23:59:59'
This one using the date date returns no results.
TPD_COLLISION_DATEBEGIN BETWEEN timestamp '5/13/2016 00:00:00' AND timestamp '5/13/2016 23:59:59'
Actually I can not get any TPD_COLLISION_DATEBEGIN query to work.
That was totally it...