[Dbix-class] Search - prefetch and left joins problem

Matt S Trout dbix-class at trout.me.uk
Fri Jun 8 17:55:18 GMT 2007


On Fri, Jun 08, 2007 at 04:18:07PM +0100, Anthony Gladdish wrote:
> Hi there,
> 
> 1. My tables and relationship aliases:
> 
> submission *has_many* submissionfields
> 
> submissionfields *has_many* submissions_field_options
> submissionfields *many_to_many* fieldoptions
> So, submissions_field_options is the many to many join table between
> submissionfields and fieldoptions
> 
> submissionfields.field *belongs_to* field
> field.field_type_input *belongs_to* field_type_input

Try the dev release, I re-wrote a fair chunk of the infrastructure in there
to make this sort of thing work.

Sadly the 07 series is simply incapable of behaving intelligently enough, so
your best bet is to help us test 07999_05 so we can get 08000 out the door.

-- 
      Matt S Trout       Need help with your Catalyst or DBIx::Class project?
   Technical Director    Want a managed development or deployment platform?
 Shadowcat Systems Ltd.  Contact mst (at) shadowcatsystems.co.uk for a quote
http://chainsawblues.vox.com/             http://www.shadowcatsystems.co.uk/ 



More information about the Dbix-class mailing list