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; } } }

QueryTask + Query with TOP Values

EvelynHernandez

Hello me again.
Im trying to find any info about making queries with the TOP (n) relation as its in SQL or another kind of DB languages.
Is it possible to do it with flex?

The only things that i have found its something about using StatisticDefinition parameters, but it doesnt allow to use TOP.
Thanks for ur help (:

Najděte více příspěvků označených jako

Accepted answers

AndreasRuloffs2

Hello,
what you can do is to do a subselect in the WHERE Clause, like that:

OBJECTID IN (SELECT TOP 20 OBJECTID FROM [SAME_TABLE])

The inner Select selects the first 20 OBJECTIDs from the Table, the Layer gets its data from.
The outer select limits then the query to the results you want.
Be careful, the innerselect may be a problem, if your featureclass is versioned.
Hope this will help you,
Andreas Ruloffs

All comments

EvelynHernandez

Oh ok.
Thanks for all ur help guys i really appreciate it (:

AndreasRuloffs2

Hello,
what you can do is to do a subselect in the WHERE Clause, like that:

OBJECTID IN (SELECT TOP 20 OBJECTID FROM [SAME_TABLE])

RobertScheitlin__GISP

Evelyn,

Using SQL functions like TOP would mean that you have to have access to the whole select statement and that is not possible on ArcGIS Server. You only have access to the Where clause portion of the select statement.

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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