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

Field Map not loading layer with SQL statement

ChetShuler

I created an outfalls inspection app for our crews to manage daily inspections. The previous ArcMap service works just fine. However after moving the app to Pro and a creating a Hosted Feature Service I had to rewrite the statement. It works fine within the Pro as well as the New Viewer on AGOL. But when I load the map into Field Maps the layer containing the SQL statement will not load. I created a couple of views and added the statement with no progress. The images below shows the statement and the points are filtering correctly.

Statement

New Viewer Perfect!!

Perfect! Magenta are due

The magenta points are past due which is exactly what I need. My problem is the layer containing the statement will not show or load into Field Maps. I'm finding the Hosted Feature Services have quite few limitations.. 😥

Find more posts tagged with

Accepted answers

All comments

ChetShuler

ArcGIS Online. I having the crew input the date.. So I have a date field to query from.. I have the definition query shown in my image screenshots. I didn't see any way to enter custom queries from the service.. I didn't see any way adding to the date inspection in the built in pulldown query statements. I wrote the query in PRO. So I might be missing something??

MitchellGrafstein

I know we had an issue with being able to take down offline areas in ArcGIS Field Maps when a date filter was being used. This issue persisted even into recent AGOL versions, and I believe that still will not work. (I think there may be a post specifically on that in the forum now and it is in the queue to be fixed I believe.)

I do believe those queries worked online for us. Probably have to see what the viewDefinitionQuery is within the service. Is this in ArcGIS Enterprise or ArcGIS Online?

For ours, this syntax being used within the viewDefinitionQuery was this:

inspection_date BETWEEN CURRENT_TIMESTAMP- INTERVAL '30' DAY AND CURRENT_TIMESTAMP

The above did work online in Field Maps, but offline areas would end up timing out. We ended up using a special field to calculate whether we wanted data to be visible based on similar criteria and used that separate field's values instead as a workaround.

The above would work online but fail when creating an offline area.

I hope some of the above helps.

ChetShuler

I tried that.. Its works in everything but field maps..

ChristopherCounsell

Can you publish the layer without the definition query, then apply it as a View filter?

You could also apply it as a Web Map filter but this can cause issues with offline and I don't recommend sharing the original Feature Layer (always use Views to share your data...)

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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