topic Re: Query max numeric value in ArcGIS Enterprise Questions

Query max numeric value

WalterDziuba1 — Tue, 20 Mar 2018 16:48:09 GMT

Afternoon,

I need to query out the max(result_numeric) value from my feature service.

Result_Numeric is of type (numeric(38,8)

Since only where clauses can be used, I'm trying this sql statement:

where requestor = 'Jack'

and RESULT_NUMERIC = (

select MAX(RESULT_NUMERIC) AS MAX_RESULT from My_Feature_Service

where requestor = 'Jack')

Can anyone add some assistance?

Walter

Re: Query max numeric value

JoshuaBixby — Tue, 20 Mar 2018 17:27:48 GMT

Some ideas here that I think will work: https://community.esri.com/thread/177516

Re: Query max numeric value

WalterDziuba1 — Tue, 20 Mar 2018 19:19:58 GMT

Joshua,

That's perfect. Appreciate your help on this topic.

Walter

Re: Query max numeric value

WalterDziuba1 — Fri, 23 Mar 2018 15:03:53 GMT

Now that I am able to retrieve the max numeric value from my feature service, it seems that the geometry is not being returned, even though return geometry is set to true.

Is this working as designed, or am I missing something?

Walter