Custom RSS feed with Drupal
Posted on 2010-08-17
I need to create an RSS feed for our press releases. I've tried the aggregator module that comes with Drupal, but it's throwing an error and I don't have time to debug and see what's wrong.
We've got a view established, so I pulled the SQL statement that pretty much gives me what I want and need. It's listed below.
Basically what I want is a template for a standard RSS feed where all I need to do is fill in the SQL statement and my DB info. You'd think that would be pretty easy to find, but evidently not.
Thanks in advance for any help you can offer.
Here's the SQL:
SELECT node.nid AS nid, node_data_field_news_date.field_news_date_value AS node_data_field_news_date_field_news_date_value FROM node node LEFT JOIN content_type_news node_data_field_news_date ON node.vid = node_data_field_news_date.vid WHERE (node.status <> 0) AND (node.type in ('news')) ORDER BY node_data_field_news_date_field_news_date_value DESC