drupal利用 views 获得用户文章汇总

dashan 提交于

论坛: 
drupal 基础
说要写自己写模块和sql的都是胡扯，让你自己写写模块（一般情况下）都是臭流氓。
views中本来就有....
创建一个新view，内容是用户
Add relationships -> Content authored
Other中 -> Aggregation
然后就可以再Fields中使用统计功能了。
*还可以有最大最小很丰富的功能
我感觉是做成区块然后配合 CONTEXTUAL FILTERS 再别的地方调用比较方便。
I want to create a list of users registered in the website using Views and, beside the names, I want to show the corresponding number of nodes they created. I know there are some contributed modules that consolidate and do some sum (never used them, though), but as I was doing some research, it seems these modules are targeted for Drupal 6. Is there a solution for Drupal 7?
Example of the expected output:
Carl (27)
John (18)
Susan (16)
Lorren (13)
Jane (5)
Norman (4)
... 
You just need Views 3. No additional modules.
1. Make sure you have the latest views 7.x-3.x-dev version installed. In general, it has the least number of bugs (at least until beta4 arrives)
2. Create a new users view (add new view, show: "Users")
3. Add a relationship: "User: Content authored"
4. In the last fieldset on the right ("Other"), select Use grouping: "Yes"
5. Add a Content: nid field, and when asked for the grouping function ("Group type"), select "Count". Uncheck the "create a label" checkbox in the configure field screen, so that it only shows the number.
And you're done.