"Latest Articles" Should be Unique
bkonia - August 9, 2005 - 23:58
| Project: | Article |
| Version: | HEAD |
| Component: | Code |
| Category: | feature request |
| Priority: | normal |
| Assigned: | msameer |
| Status: | closed |
Description
If you assign an article to more than one term, it may appear multiple times in the "Latest Articles" box. I'm requesting that you modify the code to prevent this from happening. Each article should only appear once in the Latest Articles box, regardless of how many terms it may be assigned to.
#1
I've created a patch that will execute an SQL query that will return only distinct nodes. I was working against drupal 4.6.3
#2
I believe the maintainer only has intermittent Internet access. This needs to be updated in CVS by someone and/or the maintainership changed.
#3
I've applied the patch to the CVS version.
I'm not closing this as I need to replace article_select_nodes() by a drupal API call. I'm also not sure whether DISTINCT is MySQL specific or not (PostgreSQL ?)
#4
#5