Using SQL in the Filter for a Web Map

Question

In Pro we can use a SQL definition query to filter related tables that meet criteria.

We can (and do) publish those as a Feature Service and it holds true when it gets to a Web Map.

In Web Maps it seems we can only Filter using basic filtering.

Is there a way to use SQL in the Filter so it can be written in only in the Web Map and not the service?

NickHarvey · Answer

If it were me - I would mark this as solved because this suggestion totally works.  This was really helpful for adding a fairly large, nested query that I built using Pro.  Thanks a bunch Josh.

ArmstKP · Answer

@jcarlson Is there any way in the ArcGIS Online Assistant to obtain the logged-in user and then filter a layer's field for that value, for example in an "assigned_to" field?

RobertBorchert · Answer

Thanks.  I didn't even think of that. We have used the assistant quite often when moving thins from AGO to Portal.  I will give that a shot.