[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