[Geoserver-devel] Re: [Geotools-gt2-users] Sorting queries on DataStore

A similar set of ideas have been going around the Geoserver list (ccd).
The solution is documented in the new Filter1.1 spec, and Chris Holmes
(ccd) is looking into this.

Hope this helps,

David

On Wed, 2005-02-16 at 06:43, Paolo Rizzi wrote:

Hi all,
it seems to be no way to specify an ordering for features returned
by a query to a DataStore.
Maybe it's because ordering is not supported in WFS either...

Is there any prevision of implementing it in GeoTools any time soon???

If not, I found these possible solutions / workarounds:
.) Create an ordered view in the RDBMS and query that (CONS: don't like it).

.) Create a WrappingDataStore capable of sorting features from a wrappee
(CONS: it's a waste of resource, since the RDBMS can sort on its own).

.) Patching XXXDataStore (for me it will be PostgisDataStore) to interpret
special "ordering" Filters putting them into an "ORDER BY" clause instead
that into the "WHERE". (CONS: it'll work only with "patched" DataStores).

Does anyone has any idea on this matter???

Bye
Paolo Rizzi

__________________________________________________________________
Tiscali Adsl 3 Mega Flat, 3 MESI GRATIS!
Con Tiscali Adsl 3 Mega Flat navighi in Rete alla supervelocita'
a soli 29.95 euro al mese senza limiti di tempo. Attivati entro
il 28 Febbraio 2005, 3 MESI sono GRATIS
Scopri come http://abbonati.tiscali.it/adsl/sa/2flat_tc/

-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_ide95&alloc_id396&op=click
_______________________________________________
Geotools-gt2-users mailing list
Geotools-gt2-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users