XY Event Source layer and its Output Statistics field in Query Layer for count of all entities

SvivaManager — Thu, 24 Sep 2015 12:03:24 GMT

Hello,

I have a published map service at my server which holds up 14 different types of layers and 4 additional tables as well.

When trying to query each one of those layers everything works perfectly fine.

Here are the most basic and minimal parameters I insert - Where: 1=1, Input Spatial Reference: 2039, Output Spatial Reference: 2039

The results returns perfectly fine on all layers.

When I insert the syntax below at the Output Statistics field, the result should show a count of all entities instead of returning a list of all entities and for most of the layers it works perfectly fine! except one specific layer which is an XY Event Source Data Type.

This layer is just a reflection of a table containing XY columns but yet it's published any other feature layer in the service and when trying to count it with the syntax below it throws a generic error of "unable to complete operation".

Here's the count syntax for the REST services screen for the Output Statistics field -

[{"statisticType":"count","onStatisticField":"OBJECTID","outStatisticFieldName":"result"}]

DId anyone happen to try this before?

I actually found this problem through the count widget in the operations dashboard

the count widget just doesn't show a number from the above reason

topic XY Event Source layer and its Output Statistics field in Query Layer for count of all entities in Developers Questions

XY Event Source layer and its Output Statistics field in Query Layer for count of all entities