Wen, as far as I know, it is not possible to specify a "sort by" ordering of a source type. The app-schema plugin uses the natural order of the source data store; I am not even sure if it sorts by primary key under all circumstances (such as denormalised sources when joining is not used (see the mapping file page in the manual)). If you need a particular ordering, a view seems to me like a good solution.
Kind regards, Ben. On 29/09/15 10:35, Yin, Wentao (IS) (Contr) wrote: > Is it possible to specify the "sort by" when using sourceType? > > <sourceDataStore>datastore</sourceDataStore> > <sourceType>GEOLOGICUNIT</sourceType> > > If I want to sort by a column which is not the primary key, do I have to use > View instead of Table? > > Thanks > Wen > > > > ------------------------------------------------------------------------------ > _______________________________________________ > Geoserver-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users > -- Ben Caradoc-Davies <[email protected]> Director Transient Software Limited <http://transient.nz/> New Zealand ------------------------------------------------------------------------------ _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
