where clause in associated model

[yawnt]

Let's say i have a Link model that hasMany(Tag)

it'd be cool if i could find every Link where Tag.name is in ["one","two","three"]

i saw node-persist has something like that

if you have any idea on how i could implement that i'd be happy to do it myself and submit a pull request

[janmeier]

This functionality is already implemented in #214.

Please clarify with a code example if everything does not work as expected ;-)

[gustavohenke]

@janmeier, what he asked has nothing to do with #214.
He wants to do, basically, this:

Link.all({ where : { 'tag.name' : ['one', 'two', 'three'] });

What would result in a SQL something like this:

SELECT * FROM link l
INNER JOIN tag t ON t.linkId = l.id
WHERE t.name IN ('one', 'two', 'three')

It's exactly the same thing I want right now ;D

[yawnt]

yeah.. i ended up implementing my own orm (http://github.com/coderz/hater) which has it :P

[sdepold]

so we can just copy and paste your stuff :D easy 😆

[mickhansen]

I believe this is possible in the current master. Closing.

[mickhansen]

More advanced stuff implemented in #1199