Hello,
We have created a Query Layer in ArcGIS Pro. It connects to a SQL Server database asking for the result of a SQL Server function (not a View). Its syntax is as shown below, where (7) indicates the number of days:
SELECT * FROM [<database name>][admin][<function name>](7)
In ArcGIS Pro this query works perfectly and we can see the result. It includes a geometry field (XY points) as SHAPE and some other attributes.
Later we load it as a Web Layer to ArcGIS Enterprise without any error. But when we try to create a Web Map and load this layer, the obtained table appears without any values in Map Viewer. No further information is provided by the software.
The final aim of this query is to get a dashboard.
The database is included in the data stores and it gets validated correctly.
What may be the reason of this error?
Thank your for your help.
