[CDBI] Ordering by a foreign column

Ken Youens-Clark kyclark at gmail.com
Mon Nov 21 21:00:16 GMT 2005


I've been hacking the "Hops" Catalyst sample CRUD application for my  
own evil purposes, and I've gotten lots of stuff working relatively  
easy.  For a couple of days, however, I've been stuck on how to get  
my "list" view of a table to be able to sort on any of the columns  
shown, including those from a foreign table (e.g., the "stringified"  
version of a foreign key).  My model classes are based on Class::DBI,  
of course, so I'm writing here to ask for guidance.

I Googled and found a similar thread ("order by a foreign key") from  
back in August of this year:


I've followed through all the suggestions and have tried various  
plugins and extensions such as Class::DBI::Sweet, Class::DBI::Pager,  
Class::DBI::Plugin::Pager and Class::DBI::Plugin::RetrieveAll.  Of them:

Class::DBI::Sweet - doesn't work as advertised;  I can't get any  
sorting whatsoever to work, either on a column in the table or an  
expanded column;  actually, this module produces invalid SQL when I  
specify the "prefetch" (the arg of which should be an arrayref, not  
noted in the docs), and it seems to check the "has_a" and  
"might_have" meta_info incorrectly

Class::DBI::Pager - very cool, works great, but doesn't give me sorting

Class::DBI::Plugin::Pager - the Hops app uses this, but it doesn't  
seem to work at all for me;  it claims to handle sorting, but neither  
sorts on a table's columns or related tables' columns;  nor does it  
page the data as shown in the SYNOPSIS

Class::DBI::Plugin::RetrieveAll - works perfectly, but only for  
columns in the table

I'm really at a loss here for how to get this working.  I want my  
users to be able to sort by every column presented in a list view.   
Can anyone point me in the right direction?


PS - I sent this last week to "cdbi-talk at groups.kasei.com," but never  
saw it posted, so I'm sending again.

More information about the ClassDBI mailing list