Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
Hi everyone,
I have a setup with aggregator containing feeds that are in 2 categories at the same time. Basically, my feeds are categorized by Region and by Type.
I want to create a view that list feeds categorized in Region1 AND Type1, but that seems to be impossible.
Here is my query:
SELECT aggregator_item.title AS aggregator_item_title, aggregator_item.link AS aggregator_item_link, aggregator_item.timestamp AS aggregator_item_timestamp, aggregator_item.description AS aggregator_item_description, aggregator_feed.fid AS aggregator_feed_fid, aggregator_feed.title AS aggregator_feed_title, aggregator_feed.link AS aggregator_feed_link, aggregator_category.cid AS aggregator_category_cid, aggregator_category.title AS aggregator_category_title
FROM
{aggregator_item} aggregator_item
LEFT JOIN {aggregator_category_item} aggregator_category_item ON aggregator_item.iid = aggregator_category_item.iid
LEFT JOIN {aggregator_category} aggregator_category ON aggregator_category_item.cid = aggregator_category.cid
LEFT JOIN {aggregator_feed} aggregator_feed ON aggregator_item.fid = aggregator_feed.fid
WHERE (( (aggregator_category.cid = '57' ) )AND(( (aggregator_category.cid IN ('16')) )))
ORDER BY aggregator_item_timestamp DESC
LIMIT 2 OFFSET 0
This shows me nothing. Seems logical : if I add a field "Category ID", my item appears twice, once with category 57 and once with category 16 (no filter applied).
Any idea how create this view ? Is this a problem with how Aggregator works ?
Comments
Comment #1
mzwyssig CreditAttribution: mzwyssig commentedComment #2
MustangGB CreditAttribution: MustangGB commented