[Dbix-class] Dynamic/Flexible DBIC views
    David Cantrell 
    david at cantrell.org.uk
       
    Fri Nov 21 17:48:07 GMT 2014
    
    
  
On Fri, Nov 21, 2014 at 08:38:33AM -0500, Christian Lackas wrote:
> I have something like this in the view:
>     __PACKAGE__->result_source_instance->view_definition(q[
>         select ... from projects me
>           inner join ( select ... ) join_name
>         where me.customer_id = ? and ...
>     ]);
> 
> and then can get the desired information with
>     my $res = $view->search( {}, { bind => [ 42 ] } );
>
> [but bind values are icky]
When I had a similar problem a couple of years ago I was told that what
you're doing here is the best solution. If anyone has come up with
something better since, I'd love to know too.
-- 
David Cantrell | top google result for "topless karaoke murders"
Compromise: n: lowering my standards so you can meet them
    
    
More information about the DBIx-Class
mailing list