Update: Added code to generate the params.

Hmm - that might be pretty hard (I assume that you want an article that is linked to all of the tags in @with instead of the castaway's interpretation). Here are some loose thoughts.

Lets take a bit simplified case where the @with contains the articlelinks ids and not think about the @without part at all. Than you need a query like:

SELECT * FROM 
article, articlelinks, articlelinks articlelinks_2, articlelinks artic
+lelinks_3 ...
WHERE
article.id = articlelinks.article AND articlelinks.id = $with[0] AND
article.id = articlelinks_1.article AND articlelinks_1.id = $with[1] A
+ND
...
[download]

To produce this with DBIC you need something like:

my %params;
$params{'articlelinks.id'} = $with[0];
for my $i ( 2 .. (scalar @with) - 1 ){
    $params{"articlelinks_$i.id"} = $with[$i - 1];
}
my @articles = $schema->resultset('articles')->search(
    \%params,
    {
        join => [ 'articlelinks' x scalar( @with ) ]
    }
);
[download]

The @without part is a bit simpler, thanks to De Morgan lows. But how to compose those two parts? In raw SQL I would use 'EXCEPT' but in DBIC? And how to go from the list of 'articlelinks' ids to tags?

More questions than answers here - but I've heard mst was looking for hard cases so perhaps some day he shall simplify that? I'm interested - as I use a similar structure in my bookmarking app.

---

---

• Are you posting in the right place? Check out Where do I post X? to know for sure.
• Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:

  <code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>

• Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
• Want more info? How to link or How to display code and escape characters are good places to start.