[Dbix-class] order by field?

Peter Rabbitson rabbit+dbic at rabbit.us
Tue Dec 18 08:21:51 GMT 2012


On Mon, Dec 17, 2012 at 11:04:22AM +0100, QE :: Felix Ostmann wrote:
> I am doing such a order with the following SQL:
> 
> ...
> ORDER BY
>   (department = 'Marketing') DESC,
>   (department = 'Sales') DESC,
>   (department = 'Financial') DESC,
>   (department = 'IT') DESC,
>   (department = 'Operations') DESC,
>   ...
> 
> But there is no special way to use this with DBIx::Class :-/
> 

Can you elaborate? You can always do:

order_by => \' anything you feel like goes here'.

Is this not sufficient?

Cheers




More information about the DBIx-Class mailing list