[Dbix-class] Re: Support for inline where (left join with extra condition)

Dagfinn Ilmari Mannsåker ilmari at ilmari.org
Wed Mar 13 22:38:02 GMT 2013


brew <brewsterbear at gmail.com> writes:

> Hi,
>
> Anyone know of native support queries like:
>
> SELECT * FROM artist a LEFT JOIN cd c *ON a.name = c.artist AND c.year =
> 2000*
>
> Note the complex on clause.

Yes, this is now supported by custom join conditions, which give you the
full power of SQLA to build your ON clause. See the bit about "custom
join condition coderef syntax" in:

https://metacpan.org/module/DBIx::Class::Relationship::Base#condition

-- 
- Twitter seems more influential [than blogs] in the 'gets reported in
  the mainstream press' sense at least.               - Matt McLeod
- That'd be because the content of a tweet is easier to condense down
  to a mainstream media article.                      - Calle Dybedahl




More information about the DBIx-Class mailing list