Re: DBIx::Class and many-to-many searching

[castaway]

Hi, If you already have an array of tag row objects, then you want to do something like this:

@with = map { $_->id } @with;
@without = map { $_->id } @without;

my @articles = $schema->resultset('articles')->search({}, 
 { join => { 'articlelinks' => 'tag' },
   tag.tag => { '-not_in' => \@without, '-in' => \@with } });

This is basically an SQL::Abstract construct, look there for details.

(Untested!)

C.

Update: Fixed code.. maybe

PS: This will return all articles with any of the tags in @with, there's a discussion going on in #dbix-class as to whether you wanted any, or all of them..

Please give an example of the SQL you'd like to produce, for further help

[tye]

tag.tag is likely not what you want:

$_= $_->id() for @with, @without;
my @articles= $schema->r­esultset('­articles')­->search(
    {­}, 
    {   join => { 'articleli­nks' => 'tag' },
        'tag.tag' => { '-not_in' => \@without, '-in' => \@with },
    },
);

[BrentDax]

For the record, I'm looking for articles with all of the tags in @with and none of the tags in @without.