如何在drupal视图中添加DISTINCT，GROUP BY子句

I'm using drupal 6 and i've created a view and in view query i want to add

我正在使用drupal 6,我已经创建了一个视图,并且在视图查询中我想添加

GROUP BY AND DISTINCT CLAUSE.

分组和不同的条款。

For that i tried to use views_groupby contributed module but it only provide COUNT SQL Aggregation Function.

为此,我尝试使用views_groupby贡献模块,但它只提供COUNT SQL聚合函数。

I don't know how to add group by clause and distinct clause in view query using hook_views_query_alter(&$view, &$query).

我不知道如何使用hook_views_query_alter(&$ view,&$ query)在视图查询中添加group by子句和distinct子句。

So that it look like this -

所以它看起来像这样 -

SELECT DISTINCT(node.nid) AS nid, OTHER_COLUMN 
FROM TABLE_NAME 
JOIN ANOTHER_TABLE ON JOIN_CONDITION 
GROUP BY nid

Any help or suggestion would be greatly appreciated.

任何帮助或建议将不胜感激。

4 个解决方案

#1

On your View edit form, under Basic Settings, try turning the Distinct setting on.

在“视图”编辑表单的“基本设置”下,尝试打开“不同”设置。

You may also try to use the Gear Icon for the Style section under Basic Settings. There you can specify a field to group by, if your row style is fields.

您也可以尝试在“基本设置”下的“样式”部分使用“齿轮图标”。如果您的行样式是字段,则可以指定要分组的字段。

4 个解决方案

#1

更多相关文章

随机推荐