topic Re: QueryTask + Query with TOP Values in ArcGIS API for Flex Questions

QueryTask + Query with TOP Values

EvelynHernandez — Mon, 17 Feb 2014 19:25:47 GMT

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 (:

Re: QueryTask + Query with TOP Values

RobertScheitlin__GISP — Mon, 17 Feb 2014 23:40:27 GMT

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.

Re: QueryTask + Query with TOP Values

AndreasRuloffs1 — Tue, 18 Feb 2014 07:15:04 GMT

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

Re: QueryTask + Query with TOP Values

EvelynHernandez — Tue, 18 Feb 2014 09:40:11 GMT

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