AnsweredAssumed Answered

ArcGIS Srv 10.3 advanced query

Question asked by FloCAD on Jun 30, 2015
Latest reply on Jul 3, 2015 by FloCAD

Hello everyone !

 

I would like to do an advanced query by the Rest API which look like something like this :

SELECT CAST(AVG(nbr_trip) AS integer)

FROM (

  SELECT id_people, count(id_trip) AS nbr_trip

  FROM base.trip

  GROUP BY id_people

  ORDER BY id_people

) AS tmp_query

 

My goal is to return back only a number which is the average of a count but the REST UI doesn't seem to allow me to do that...

 

Someone could help me please ?

 

Thx by advance !

Outcomes