[Dbix-class] Using { count => 'me.list_id' } with AS hack from the FAQ

Kevin Old kevinold at gmail.com
Mon Oct 9 21:46:55 CEST 2006


Hello everyone,

I'm trying to use the hack defined in the FAQ for "sort my results
based on fields I've aliased using as" with the following statement
which includes a count.

$schema->resultset("MyTable")->search(undef, { select => [ { count =>
'list_id'} ], as => [ 'list_count' ] });

Can someone give me the syntax for this statement for the hack?  I've
tried just about every combination of inserting \' as list_count' but
nothing seems to work.

Any help is greatly appreciated,
Kevin
-- 
Kevin Old
kevinold at gmail.com



More information about the Dbix-class mailing list