is it possible add condition into left join?

[Marek Lichtner]

e.g.
$software->application('author.id > 10');
SELECT application.*
FROM application
LEFT JOIN author ON application.author_id = author.id
WHERE (author.id > 10);

Exists any way how to do this?:
SELECT application.*
FROM application
LEFT JOIN author ON application.author_id = author.id AND (author.id
> 10);

[Jakub Vrána]

No, it's not very NotORM-ish. What is a use-case for this?

Jakub Vrana

[Yuri Kuznetsov]

Hi

I like your library and very appreciate the work you've done. 

I have similar question regarding JOINS.

Is it possible to get relationships with relation_type field specified. E.g. I want to get all comments which belong to the blog record.

Maybe something like this:

$row->bean_comment()->via('bean_id')->where('bean_type','Blog');

where bean_comment table has next fields:

* bean_id

* bean_type

* comment_id

Thanks

[Jakub Vrana]

Hi,

Yes, this is supported. via() shouldn't be necessary.

Jakub