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.. 😥

[MitchellGrafstein]

Seems the query may not be saving at the layer level, and it very may might matter how it is being constructed then.  

Edit - Also, unfortunately, complex filters at the layer level will not show up as it suggests.  Are you trying to filter the layer itself?  Or are you trying to filter just at the map level?  Or both? 

I'm off for the day, but I can take another look here tomorrow.

[ChetShuler]

Thank and no hurry.. I been told to start migrating over to the Cloud. I saved all the original apps.. Still a lot of short coming with Hosted Feature Services.