Re: [Qgis-user] Layer classification: order by clause?

2007-11-18 Thread Tim Sutton
Hi

Did you try making a view that specifies the sort order?

Regards

Tim

2007/11/12, Frank Broniewski <[EMAIL PROTECTED]>:
> Dear list,
>
> I am trying to make archaeological distribution maps with qgis. I have my site
> data stored in a postgis database and can connect to it.
> My problem lies in the drawing order of the classified attribute field. For me
> it is crucial to have my attribute values (epoches in my case) to be drawn in
> the correct order - that is from latest time period to most recent.
> But qgis draws the attribute values always in alphabetical order from a to z.
> I tried to use a "order by" clause in the sql query builder, but this doesn't
> seem to work. I tried also to reorganize the epoch classes in the legend
> composer, but this doesn't work also.
> So, is there a way to achieve this?  I use qgis 0.9.0 on ubuntu 7.04 installed
> by apt-get.
>
> Any help is greatly appreciated!
>
> Frank
> ___
> Qgis-user mailing list
> Qgis-user@lists.qgis.org
> http://lists.qgis.org/cgi-bin/mailman/listinfo/qgis-user
>


-- 
Tim Sutton
QGIS Project Steering Committee Member - Release  Manager
Visit http://qgis.org for a great open source GIS
openModeller Desktop Developer
Visit http://openModeller.sf.net for a great open source ecological
niche modelling tool
Home Page: http://tim.linfiniti.com
Skype: timlinux
Irc: timlinux on #qgis at freenode.net
___
Qgis-user mailing list
Qgis-user@lists.qgis.org
http://lists.qgis.org/cgi-bin/mailman/listinfo/qgis-user


[Qgis-user] Layer classification: order by clause?

2007-11-12 Thread Frank Broniewski
Dear list,

I am trying to make archaeological distribution maps with qgis. I have my site 
data stored in a postgis database and can connect to it.
My problem lies in the drawing order of the classified attribute field. For me 
it is crucial to have my attribute values (epoches in my case) to be drawn in 
the correct order - that is from latest time period to most recent. 
But qgis draws the attribute values always in alphabetical order from a to z. 
I tried to use a "order by" clause in the sql query builder, but this doesn't 
seem to work. I tried also to reorganize the epoch classes in the legend 
composer, but this doesn't work also.
So, is there a way to achieve this?  I use qgis 0.9.0 on ubuntu 7.04 installed 
by apt-get.

Any help is greatly appreciated!

Frank
___
Qgis-user mailing list
Qgis-user@lists.qgis.org
http://lists.qgis.org/cgi-bin/mailman/listinfo/qgis-user