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

mzwyssig’s picture

Component: Miscellaneous » aggregator data
MustangGB’s picture

Status: Active » Closed (outdated)