nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Query max numeric value

WalterDziuba1

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

Trouver plus de publications taguées avec

Accepted answers

JoshuaBixby

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

All comments

JoshuaBixby

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

WalterDziuba1

Joshua,

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

Walter

WalterDziuba1

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

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.