Bonsoir,
J’ai la requête SQL suivante :
self.find_by_sql([%{
SELECT categories.id, categories.name, categories.permalink,
categories.position, COUNT(articles.id) AS article_counter
FROM #{Category.table_name} categories
LEFT OUTER JOIN #{Category.table_name_prefix}categorizations#
{Category.table_name_suffix} articles_categories
ON articles_categories.category_id = categories.id
LEFT OUTER JOIN #{Article.table_name} articles
ON (articles_categories.article_id = articles.id AND
articles.published = ?)
GROUP BY categories.id, categories.name, categories.position,
categories.permalink
ORDER BY position
}, true]).each {|item| item.article_counter =
item.article_counter.to_i }
Que je cherche à transformer en ça :
self.find(:all, :include => :articles, :order => 'position
ASC’, :conditions => “contents.published = 1”, :group =>
‘categories.id, categories.name, categories.position,
categories.permalink’, :order => ‘position’)
Malheureusement je n’arrive pas à voir comment récupérer
l’article_counter de la première requête. Quelqu’un aurait une idée ?
Merci d’avance
Frédéric
Frédéric de Villamil
[email protected] tel: +33 (0)6 62 19 1337
http://fredericdevillamil.com Typo : http://typosphere.org