Using SQL in the Filter for a Web Map

[RobertBorchert]

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?

[Jelle_Stu_PR]

Not that I am aware of. A workaround could be to add a field in Pro that defines if features holds your sql query or not. And then in your we map you can filter based on that field. This does require a regular extra analysis of your feature class if it regularly gets updated.

[RobertBorchert]

Thats is a pretty good idea and I can see it working for other applications we use. However, the table (short name is EVW) is generated from an export from our Primavera application and it contains the status of every project.  And is updated every Monday the analysis could be triggered as part of the SQL that exports the table. The table would be related to a different table that has Field Project status updated and that can change by the minute and would not reflect in the other table.  However, you have given me ideas for other uses for your suggestion. 

[jcarlson]

Using the ArcGIS Online Assistant or Python, you can access the SQL statement reflected in the filter settings, and adjust it however you like. The string is stored in the Web Map's JSON as the "definitionExpression" property.

{
    "operationalLayers": [
        {
            "id": "Sales_Hosted_2910",
            "layerType": "ArcGISFeatureLayer",
            "url": "https://services6.arcgis.com/U1zX3Wx8hhY7Gb30/arcgis/rest/services/Sales_Hosted/FeatureServer/0",
            "visibility": true,
            "opacity": 1,
            "title": "Sales_Hosted",
            "itemId": "a405b06ae8e24f94a2768a4581b79e73",
            "layerDefinition": {
                "definitionExpression": "valid_sale = 1",
            ...

[RobertBorchert]

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.

[ArmstKP]

@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?

[NickHarvey]

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.