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