I have a layer hydrant and a related table hydrant inspection that live in an Enterprise SDE. I want to visualize the hydrants based on if certain fields have been marked Yes or No in the hydrant Inspection table.
On the hydrant Inspection table I did a definition query of "maintcomplete IS NULL And followup = 1" so it only give me records saying that it needs follow up and that follow up hasn't been completed. I then joined by hydrant layer to the the hydrant Inspection record with the definition query. I then Shared this as a Map Image Services to my portal.
I'm now able to visualize the hydrant that have the follow up marked as 1 (Yes) and the layer updates as new inspections are added via Field Maps or as the Maintenance Completed field is filled out.
I then go to put this functioning Web Map into a Dashboard and the indicator widget or other items to be able to see data on this layer and when I select this joined feature service within Dashboard I get "Cannot Access Data". I go to the Server Manager logs and I'm getting "Geodatabase error: The SQL statement was not a select statement."
Does Dashboards have the ability to pull data from the Joined feature services? I'm able to view the table of attributes of this Joined feature service in the web map without issue. Or do I need to modify my definition query?
