On Mon, 8 Oct 2018 15:26:41 + David Cantrell wrote:
> I'm having trouble figuring out how to express one of my joins in
> DBIx::Class.
>
> The two tables involved and some relevant sample data are:
>
> > select * from serviceplan_price;
> +++---+---+--
On Tue, Oct 09, 2018 at 08:48:33AM +0200, QE :: Felix Ostmann wrote:
> i did not see a problem with you current approach. It is simple you dislike
> literal sql?
It's partly an aesthetic objection, but also I didn't like having to
repeat the filters on type and id. But if there's no better way I'
Hi David,
i did not see a problem with you current approach. It is simple you dislike
literal sql?
You could write the subselect as a dbic statement and call as_query() and
use it, see
https://metacpan.org/pod/distribution/DBIx-Class/lib/DBIx/Class/Manual/Cookbook.pod#Correlated-subqueries
my $i
Hello gang!
I'm having trouble figuring out how to express one of my joins in
DBIx::Class.
The two tables involved and some relevant sample data are:
> select * from serviceplan_price;
+++---+---+-+
| id | serviceplan_id | type | value | effectiv