Sorting by a Select Field (Taxonomy)

[harley77]

I'm trying to sort an item list by a Select Field that draws it's data from the Taxonomy tree using the "Order By" box . It does sort it, but it sorts it by the ID# of the Field rather than the name itself..which makes little sense (from a usage standpoint). Is it possible to have it sort by the Field value rather than the ID?

[MacKP]

Hi harley77,
this is not so easy. But it will work with this (in Order by at the list Module):

(SELECT sorting FROM catalog_tablename AS cs WHERE cs.id=catalog_field) ASC

catalog_tablename is the reference... like the taxonomie at your install.

regards

[harley77]

THANK YOU! I bow before your awesomeness, that worked perfectly. I didn't realize we could use SQL statements inside the order By box.